0

NL Column Single column Subtotal

Jet Reports Historic Posts

July 06, 2012 13:26

None

Follow

Hi Folks,

The question that I have is if there is a way to get the subtotal for 1 column out of a NL("Columns=3") function.
In my case I have 3 columns Col1=Value1, Col2= Value2, Col3=Col1-Col2 (Difference). Now the issue is that in my case there are multiple "Sets" of 3 columns.
I would like to SUM or SUBTOTAL just the "Difference" Column for all sets at the end of the row in my report. Is this Possible?

Thanks for help in advance.

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 06, 2012 17:24 Official comment

  Hi,
  
  Yes, it is possible if you'd use the SUMIF function.

• 0
  
  Jet Reports Historic Posts July 09, 2012 17:12

  Great!
  
  Got it!
  
  Thanks again for the help.