Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi at all
I have this situation
So in the first table i calc the total quantity of purchased materials, first available unit price and then the total amount oof purchased for each product. Then i woul like to obtain a second table with only the total amount by "Bill".
For example in the example i would like obtain 2515 as total amount of "Conto_01" and not 2775.
I used this function
Total Quantity = sum(Quantity)
First Price = Avg({<First_Price = {1}>}Price)
Total Amount = sum(Quantity) * Avg({<First_Price = {1}>}Price)
Is it possible to obtain the target result?
Andrea
Try this
Sum(Aggr(Sum(Quantity) * Avg({<First_Price = {1}>}Price), Bill, Product))
Try this
Sum(Aggr(Sum(Quantity) * Avg({<First_Price = {1}>}Price), Bill, Product))