syntax for set analysis

[ssriramin19]

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

[pokassov · Accepted solution]

if(u1='1' or u2 <>'1',(Sum({<[LAG]=,Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))

)

[#3]

Use this one,

if(u1='1' or u2 <>'1',(Sum({<Year={$(=Max(Year))}, LAG = >}actual_Sales*[ME Curr Factor Actual]))

)

[ssriramin19]

Thanks very much for expression provided. It works as needed.

[ssriramin19]

Thanks Sergey for the expression.it works as needed.