topic Re: How to use fileter in Fractile function in App Development

How to use fileter in Fractile function

Anonymous — Tue, 13 Dec 2016 02:35:45 GMT

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

Re: How to use fileter in Fractile function

sunny_talwar — Tue, 13 Dec 2016 03:49:59 GMT

May be one of these:

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

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

Re: How to use fileter in Fractile function

Anonymous — Tue, 13 Dec 2016 07:36:51 GMT

Thanks Sunny it works.