0

NL(Sum) and filtering on two fields

Jet Reports Historic Posts

August 25, 2011 11:04

None

Follow

I'm trying to get a figure from the purchase line but the filters need to be a calculation.

I'm trying to do the below:

=NL("Sum","purchase line","Quantity","Gen. Prod. Posting Group",$I13) - so far so good

i need to insert a second filter on the lines : "Qty Invoiced" - "Quantity" = 0

is there a way how I can do this?

Thanks
Ad

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 25, 2011 14:29

  Hi Ad,
  
  You should be able to do that with a calculated filter field something like this:
  
  =NL("Sum","purchase line","Quantity","Gen. Prod. Posting Group",$I13,"=NF(,""Qty Invoiced"")-NF(,""Quantity"")",0)
  Does this work for you?
  
  Regards,
  Hughes