0

Pull a single value that has to be calculated

Jet Reports Historic Posts

March 29, 2015 14:25

None

Follow

Hello!

I need to pull the total weight on hand as a single number. Is there a way to do a calculation in the function?

Item Table: Sum (Quantity on Hand * Gross Weight) = Available Inventory by Weight

Please and Thank you.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 30, 2015 17:03

  Hello!
  
  You should be able to do a calculation that multiplies two different Jet Sum Functions such as:
  
  =NL("sum", "NAV TABLE", "Quantity on Hand")*NL("sum", "NAV TABLE", "Gross Weight")