SUM & multiply at the same time

I have two columns, in one the "Prices" of products and in another the "quantity" of them.

Is it posible to do something like the following?

[SUM(<RepDB."Price">*<RepDB."Quantity">,MasterData1,0))]

I want to get the Total Price.



Comments

  • gordkgordk St.Catherines On. Canada.
    edited 3:52AM
    yes providing that the memo that contains the expression is located in the correct footer. see user manual on using aggregate functions.
    [SUM(<RepDB."Price">*<RepDB."Quantity">,bandname)]
    you can also look at the main report demo
    master/detai/subdetail report to see an example of its use.
    ;) l
  • edited 3:52AM
    Sorry for revive this post, but i have almost the same question.

    In my case i just need to multiply quantity x price, only this.
  • gordkgordk St.Catherines On. Canada.
    edited 3:52AM
    [<RepDB."Price">*<RepDB."Quantity">]

Leave a Comment