5 Replies Latest reply: Jan 9, 2015 5:55 AM by VENKATA RAM

Expression for Unit Price * Qty

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).

Thanks

Henry

• Re: Expression for Unit Price * Qty

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

• Re: Expression for Unit Price * Qty

yes it worked, my bad wrong exp that I used

Thanks anyway.

• Re: Expression for Unit Price * Qty

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)

• Re: Expression for Unit Price * Qty

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

• Re: Expression for Unit Price * Qty

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 )