Variable in an set analysis takes Total value instead of Row value

[bharani8]

Hi Experts - Have posted this question before in a different manner.. But didn't get solution for that I had deep dive and found few more things.. At one point i got stuck, so will need the experts help on this to fix.

Here you go..

In the below table.. When i select the reporting month as Dec'16.. i get the right value under "vB2" column as 3645.. where as when i select more than a month (in this case Dec'16 & Jan'17) it gives me wrong number in "vB2" column.. and what i found is.. The variable (vFrac) which i used in creating "vB2".. it takes the total value (3) when we select more than 1 month instead of taking the value which is for that particular row(2).. Can you please help me to fix this ?

Have attached the files for your reference..

Thanks

Bharani

[sasiparupudi1]

Please change your expression to count({<sotat = {'<Aggr($(vFrac),[Reporting Month])'}>} SCHEDULE_LOGIC)

Please mark the answer as correct and helpful if you are happy with the solution

hth

Sasi

[bharani8]

Tried that.. i see all values changing to zero

[sasiparupudi1]

May be try changing vFrac to Fractile(total<[Reporting Month]>sotat,.9)

[bharani8]

Still not working

[sunny_talwar · Accepted solution]

What you pointed out here is not a problem with Fractile function, but something related to set analysis. Set analysis is evaluated once per chart, which is why it only picks a single Fractile value. Try using Aggr() instead

=Count(Aggr(If(sotat < Fractile(TOTAL <[Reporting Month]> sotat,.9), SCHEDULE_LOGIC), [Reporting Month], Key))

[bharani8]

Thanks a lot for your explanation!! Works Perfectly!