How to use fileter in Fractile function

[Anonymous]

Hi All,

I have a field called 'IT_ElapsedDays' which contains the values '-43' .

Fractile(IT_ElapsedDays,0.8) is what my KPI expression. trying to apply the filter as below which is not worrking if(IT_ElapsedDays<>-43,Fractile(IT_ElapsedDays,0.8)).

anybody have idea to solve this issue. thanks

[sunny_talwar · Accepted solution]

May be one of these:

Fractile({<IT_ElapsedDays -= {-43}>} IT_ElapsedDays, 0.8)

or

Fractile(If(IT_ElapsedDays <> -43, IT_ElapsedDays), 0.8)

[Anonymous]

Thanks Sunny it works.