Fractile issue

[emilyrabbit]

H i,

I want to find the  fractile 0.8 ,by sum  [Company Worldwide Number] , I want to ignore the external [Company Worldwide Number] selection.  And it shows "-".Could you help me ? Thanks.

fractile(TOTAL {<[Company Worldwide Number]>}
aggr( sum({<[Company Worldwide Number]= >,<Fact_Type={'FACT_ORDER'}>}
fabs([Order Net Amount in Loc Currency])),[Company Worldwide Number]),
0.8)

I scratch some data , it shouldn't be "-"

[Kushal_Chawda]

@emilyrabbit  try below. Remove total keyword from fractile

fractile( {<Fact_Type={'FACT_ORDER'},[Company Worldwide Number]=>}
aggr( sum({<Fact_Type={'FACT_ORDER'},[Company Worldwide Number]=>}
fabs([Order Net Amount in Loc Currency])),[Company Worldwide Number]),
0.8)