Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i would like to calculate amount as below ,however, no result. Can it be realized? Please help.
sum({condition A} Quantity *avg({condition B} price))
I want to Quantity * avg (price) and get sum amount. if i write as below the result is not expected.
sum({condition A } Quantity)*avg({condition B})
Try this
sum({condition A} Quantity * $(=avg({condition B} price)) )
agree with lorenzo.
i would put the avg expression in a variable so that its calculated globally