Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Another newbie question for the experts...
I am using the FRACTILE function to determine the 90% fill rate on a volume of order line items.
=FRACTILE(ORDER_TAT,0.9)
which returns me a value of 3.0
What I want to do now is see how many orders make up this value.
I thought something like:
=COUNT(FRACTILE(ORDER_TAT,0.9),order_no)
but this does not work.... I know what the values should be based on examination of the raw data in Excel. The number of records will change from month to month, so I want to calculate my fractile value (which is in days) and see the number of records supporting that.
Anyone have an idea on what I could do?
thanks,
How about:
COUNT(if(ORDER_TAT <= FRACTILE(Total ORDER_TAT,0.9),order_no))
=COUNT(if ORDER_TAT <= FRACTILE(ORDER_TAT,0.9),order_no)
-Rob
Error in that expression... is there some syntax missing around if?
=COUNT(if(ORDER_TAT <= FRACTILE(ORDER_TAT,0.9),order_no))
Some missing parenthesis.
This looks perfect to me, but I still get "error in expression"
I tried taking out the spaces around the <= as well with no luck.
very frustrating.....
How about:
COUNT(if(ORDER_TAT <= FRACTILE(Total ORDER_TAT,0.9),order_no))
that works perfectly.
You sir are a genius.
Glad I could help