Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table of lines of invoices (invoice number - date - client - item - quantity).
I need to count the invoice numbers where the total amount ordered for all items is below 10 kg. The count will be shown in a table by client.
CHRONOFA = the invoice number
TONNAGE VENDU = quantity
I've tried :
=count(distinct aggr ( if (sum([TONNAGE VENDU])<10, CHRONOFA) , CHRONOFA))
but its not giving me the right number.
I've also tried :
=Count(DISTINCT {<CHRONOFA = {"=Sum([Tonnage_Vendu]) < 10"}>} CHRONOFA)
Any ideas anyone??
Thanks!
please provide details about the dimension used
Per client, I want to count the distinct invoice numbers (field CHRONOFA) when the total sum of the quantity (field [TONNAGE VENDU]) is under 10.
I'm not sure I'm actually replying to your question... could you be more specific in what details you are interested in ?
Yes! This worked great! Thanks for your help!