0

Adding and Subtracting NL(First)

Jet Reports Historic Posts

December 09, 2016 19:55

None

Follow

Hello,

I am wanting to create a formula that will add and subtract values on the item card.

For example, show the net of the Quantity on hand, plus the Quantity on PO, less the Quantity on Component lines. I can do this is several columns, with a NL(First) for each value and then add/subtract the values in another column.

Is there a way to get the net of these values in one compound NL?

Thank you,

Pat Rounds

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts December 09, 2016 20:32

  You can always use multiple NL(First) functions in a single cell:
  
  =NL("First","Table1","Field1")+NL("First","Table2","Field2")-NL("First","Table3","Field3")…etc.
  You wouldn't be able to drill down on the data, but you would not have to list each value in its own column.