Expression for Unit Price * Qty

[#1]

HI All,

Need help about how to create expression unit price * qty ? the formula should be calculate for each row.

So when I sum total sales will be correct not (sum of unit price).

Please advice.

Thanks

Henry

[alexandros17 · Accepted solution]

Honestly I do not understand the problem, use a straight table (use a dimension) and add the following expression:

Sum([UNit Price] * qty)

Why doesn't it work?

Let me know

[Colin-Albert]

Can you post an example of your data?

sum([unit price] * qty) will work provided each data row has both unit price & qty values

otherwise try   sum([unit price]) * sum(qty)

[SunilChauhan]

only([unit price]) * only(qty)

[#5]

yes it worked, my bad wrong exp that I used

Thanks anyway.

[#6]

hi ,

sum([unit price] * qty) (or) only([unit price]) * only(qty) both are correct answers Because it works on row bases  ...but sum([unit price]) * sum(qty) gives different answer ....summation done on individual field (i.e Column wise )