topic Re: IF works but Set analysis does not work?? in App Development

IF works but Set analysis does not work??

prasadmundewadi — Tue, 20 Feb 2018 16:17:34 GMT

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

sunny_talwar — Tue, 20 Feb 2018 16:21:59 GMT

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])

dwforest — Tue, 20 Feb 2018 23:29:29 GMT

It could be is Segment changes for each record. Set Analysis is evaluated once per chart/visualization, not row for row.

prasadmundewadi — Thu, 22 Feb 2018 19:45:35 GMT

1st expression still give 0 but the 2nd one returns value which is wrong.

Digvijay_Singh — Thu, 22 Feb 2018 19:53:23 GMT

Your IF has distinct in the aggregation, may be thats making difference -

Sum(distinct {<[Booking Amount] = {">$(=$(vTopDecile))"}>}[Booking Amount])

sunny_talwar — Thu, 22 Feb 2018 21:05:31 GMT

Would you be able to share a sample to look at this?