Need help Set analysis

[#1]

Hello Friends,

As I am trying to write a expression using set analysis but I am not getting any reslut.

The thing is I have two calculated fields from the script and trying to find a a sales.

eg:

=Sum({$<Disc={'Discount'}, MoreDisc={'ExtraDiscount'}>}[Sales])

and tryed like using If contion

=Sum(if(Disc='Discount',[Sales])) + Sum(If(MoreDisc='ExtraDiscount',[Sales]))

Thanks in advnce for your help

Regards

Chriss.

[er_mohit]

using aggr function like

aggr(rangesum({$(<Disc ='Discount'{${MoreDisc='ExtraDiscount'}>}},Sales)))

hope it helps you

[jagan]

Hi,

Please try below expression

=Sum({<Disc={'Discount'} > +  <MoreDisc={'ExtraDiscount'}>} [Sales])

Hope it helps you.

Regards,

Jagan.

[#4]

Hello Jegan and Mohit,

Thanks for your solutions,

Mohit: still your expression is not working for me, its showing error in as highlighted

aggr(rangesum({$(<Disc ='Discount'{${MoreDisc='ExtraDiscount'}>}},Sales)))

Regards

Chriss

[shilpan]

Try this

aggr(rangesum({$(<Disc ={'Discount'} + MoreDisc={'ExtraDiscount'}>},Sales)))

Hope it helps,