0

How to make sum of qty * cost

Jet Reports Historic Posts

August 27, 2012 19:38

None

Follow

Hi,

The "sales line" table contains a "Quantity" and a "Unit Cost" field. Is there any trick to make a sum of the "Quantity" * "Unit Cost" for all sales lines. I know how to make a sum of the "Quantity" and the "Unit Cost" field, but not the multiplication of both. Maybe a pivot table could do the trick here, but I don't want to use it in this case.

Thanks for any help,
Regards,
Steven Debruyne

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts August 27, 2012 20:26 Official comment

  Hi Steven,
  
  You can do this using a calculated field something like this:
  
  =NL("Sum","Sales Line","=NF(,""Quantity"")*NF(,""Unit Cost"")",….)
  Does that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 28, 2012 07:35

  Yes! That was the trick!
  
  Many thanks again;-).
  
  Steven