5 Replies Latest reply: Feb 22, 2018 4:05 PM by Sunny Talwar RSS

    IF works but Set analysis does not work??

    Prasad Mundewadi


      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