Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have below expression in my app where i have used IF:
Sum(distinct If(If([Booking Amount] > $(vTopDecile) ,'Y','N')='Y',[Booking Amount],0))
The variable vTopDecile is defined as
fractile(total Aggr(Sum([Booking Amount]),[Opportunity Number],Segment), 0.9)
Now I am trying to write the same expression (the 1st one) using set analysis but that is not working. It always returns 0:
Sum({<[Booking Amount] = {"> $(=vTopDecile)"}>}[Booking Amount])
Can anybody tell me why?
Is it because fractile cannot work with Set Analysis?
Thanks, Prasad
Can you try this (Make sure you don't have space between > and $(
Sum({<[Booking Amount] = {">$(=vTopDecile)"}>}[Booking Amount])
or this
Sum({<[Booking Amount] = {">$(=$(vTopDecile))"}>}[Booking Amount])
It could be is Segment changes for each record. Set Analysis is evaluated once per chart/visualization, not row for row.
1st expression still give 0 but the 2nd one returns value which is wrong.
Your IF has distinct in the aggregation, may be thats making difference -
Sum(distinct {<[Booking Amount] = {">$(=$(vTopDecile))"}>}[Booking Amount])
Would you be able to share a sample to look at this?