Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to sum some values from a field based on another one. I would like to use something like Sum(TOTAL <Invoice Number> Sales) but, instead to use TOTAL I need to use Distinct, due to I have many re-invoices numbers belonging to the same original invoice, and of course, I need to sum just one time each.
Thanks in advance!!!
Hi,
I think you have a problem in the original data. Try to understand why you have duplicate value for a unique invoice.
But you can try this :
sum( Aggr( Max( Sales ) , Invoice Number)) )
This function retain one value for each invoice.
JJ
Hi,
I think you have a problem in the original data. Try to understand why you have duplicate value for a unique invoice.
But you can try this :
sum( Aggr( Max( Sales ) , Invoice Number)) )
This function retain one value for each invoice.
JJ
Jean-Jacques,
Very smart and very easy solution. The situation is a little complicated to explain. But your solution works perfect!!! Thank a lot!!!