Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My expression for actual sales
if(u1='1' or u2 <>'1',(Sum({<Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))
)
The above expression works fine .But the requirement is that there is a field called LAG . When LAG field is clicked the actual sales values should not change. But it is currently changing.Both actual_sales and LAG are fetched from the same table.
I know sum({<[LAG]=>} will work. This will make selections independent. But how do I need to incorporate this expression sum({<[LAG]=>} in the above actual_sales expression .
Please provide the needful on this
Thanks
Sriram
if(u1='1' or u2 <>'1',(Sum({<[LAG]=,Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))
)
if(u1='1' or u2 <>'1',(Sum({<[LAG]=,Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))
)
Use this one,
if(u1='1' or u2 <>'1',(Sum({<Year={$(=Max(Year))}, LAG = >}actual_Sales*[ME Curr Factor Actual]))
)
Thanks very much for expression provided. It works as needed.
Thanks Sergey for the expression.it works as needed.