sehow to write set analysis

[#1]

=if((Datefield) < startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))

same  expression  i need in   set analysis

[#2]

Hi,

if((Datefield) < startdate ,sum({<ABC ={'C','XYZ'}>}) - sum({<ABC ={'D','XYZ'}>}))

[jagan · Accepted solution]

Hi,

Try this

=Sum({<Datefield={'<$(=startdate)'}, ABC = {'C'} >} XYZ) - Sum({<Datefield={'<$(=startdate)'}, ABC = {'D'} >} XYZ)

Regards,

Jagan.

[#4]

Jagan

jagan  thank you  it is  working fine