Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
This works:
count(if(FCT < aggr(NODISTINCT Fractile(total<Wk_Num> FCT, 0.9),Wk_Num), PO))
See attached. You'll probably need to replace the Wk_Num with the current field of the cycle group.
Edit: In fact, it works without total as well:
count(if(FCT < aggr(NODISTINCT Fractile(FCT,0.9),Wk_Num), PO))
The secret word is still NODISTINCT
You maybe need aggr(), but what you need for sure is "total". Try this first:
=count(if(FCT<Fractile(total FCT,0.9),PO))
use
=count({<FCT<Fractile (FCT,0.9) >} PO)
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
Hi Ashwani, I got an this: "error in set modifier expression"
Can you upload a small example?
try this
=count({<FCT={'$(<Fractile (FCT,0.9))'} >} PO)
or
=count({<FCT={'<$(Fractile (FCT,0.9))'} >} PO)
May be this:
=Count({<FCT = {'< $(=Fractile(FCT, 0.9))'}>}PO)
Best,
Sunny
Not working