Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if((Datefield) < startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))
same expression i need in set analysis
Hi,
Try this
=Sum({<Datefield={'<$(=startdate)'}, ABC = {'C'} >} XYZ) - Sum({<Datefield={'<$(=startdate)'}, ABC = {'D'} >} XYZ)
Regards,
Jagan.
Hi,
if((Datefield) < startdate ,sum({<ABC ={'C','XYZ'}>}) - sum({<ABC ={'D','XYZ'}>}))
Hi,
Try this
=Sum({<Datefield={'<$(=startdate)'}, ABC = {'C'} >} XYZ) - Sum({<Datefield={'<$(=startdate)'}, ABC = {'D'} >} XYZ)
Regards,
Jagan.
Jagan
jagan thank you it is working fine