Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have Inline table
Load * Inline [ Expression_Id, ExpressionTY, ExpressionLY
1, 'sum({$<Date ={'$(=Date(Max(Date)-1))'}>} "Sales " )', 'sum({$<Date ={'$(=Date(Max(Date)-366))'}>} "Sales " )',
2, ............
];
when i call this expression in an chart expression using '=$(=ExpressionTY)'
its gives me output without considering date condition means sum(Sales) till now for both the expressions.
Thanks Anushree for replying but its didnt work.
Now i have replace $ with ~ in inline and in chart expression i used this n it worked
Replace(Expression_TY,'~','$')
Try Using:
sum({$<Date ={"$(=Date(Max(Date)-1))"}>} Sales )
and invoke the expression as =$(ExpressionTY)
Thanks Anushree for replying but its didnt work.
Now i have replace $ with ~ in inline and in chart expression i used this n it worked
Replace(Expression_TY,'~','$')