Convert IF to Set analysis

[Anonymous]

Hi All,

  How to convert the below IF expression in to Set analysis

sum(if(Periods=GetFieldSelections(Period1) and Flag1=3,[Gross Value Local Currency]))

[devarasu07]

Hi,

like this

sum({$<Periods={'$(=GetFieldSelections(Period1))'},Flag1={3}>}[Gross Value Local Currency])

or

sum({$<Periods={'$(=GetFieldSelections(Periods1))'}>+<Flag1={3}>}[Gross Value Local Currency])

Thanks,Deva

[Aurelien_Martinez]

Hi,

Sum({<Periods=P(Period1), Flag1={3}>} [Gross Value Local Currency])

Aurélien

[Anil_Babu_Samineni]

Or

sum({$<Periods={$(=Concat(Chr(39) & Period1 & Chr(39), ','))},Flag1={3}>}[Gross Value Local Currency])

Note - Second one won't work, Because + Consider in analysis as OR not AND.

[its_anandrjs]

Try this

Sum({<Periods ={"$(=GetFieldSelections(Period1))"},Flag1={3} >}  [Gross Value Local Currency])

Or

Sum({<Periods ={"$(=GetFieldSelections(Period1))"},Flag1={'3'} >}  [Gross Value Local Currency])

[pradosh_thakur]

Hi Anand

what if more than one selections are there? will it work there too? i guess we need to modify the expression for that.

regards

Pradosh