Any way to make this formula work?

[Anonymous]

I cant get this formula to work in a chart expression, I've tried with aggr and putting the expression in a variable, not sure if possible or what am I doing wrong

=count(if(FCT<Fractile(FCT,0.9),PO))

[Anonymous]

You maybe need aggr(), but what you need for sure is "total".  Try this first:

=count(if(FCT<Fractile(total FCT,0.9),PO))

[ashwanin]

use

=count({<FCT<Fractile (FCT,0.9) >} PO)

[Anonymous]

Hi Michael, unfortunately that way it won't consider my dimension field, which is the month in the x axis.

If I add it to the Total clause, it won't work again

[Anonymous]

Hi Ashwani, I got an this: "error in set modifier expression"

[Anonymous]

Can you upload a small example?

[Anonymous]

try this

=count({<FCT={'$(<Fractile (FCT,0.9))'} >} PO)

[Anonymous]

or

=count({<FCT={'<$(Fractile (FCT,0.9))'} >} PO)

[sunny_talwar]

May be this:

=Count({<FCT = {'< $(=Fractile(FCT, 0.9))'}>}PO)

Best,

Sunny

[Anonymous]

Not working