Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am trying to get the total suppliers with 80% of the purchase orders amount.
I was able to do it in a straight table, by using the following expression:
= sum ( aggr ( If ( Rangesum ( Above ( sum ( Amount) ,0 , Rowno() )) / sum ( Total Amount ) <= 0.8, 1 , 0) , BP ))
This expression works if the table is sorted by purcahse order amount in a desc order.
But, I want to use this in a text object to display only the count of suppliers with 80% of the purchases.
If I use the same expression in text object it doesn't display the correct result becasue there is no sort.
I know in QV 12 there is a solution for it in AGGR fucntion, but I am using QV11.
Thanks,
Karin
Hi,
Try to use the Rank function
Check here
Thanks, but as I see they it refers to the same AGGR function with QV 12 or use a button to calculate the pareto (which is not what I need).