0

Select by difference between fields

Jet Reports Historic Posts

March 19, 2010 16:03

None

Follow

I'm looking at a Customer Ledger payment entry & there is a difference between the "Original Amount" & the "Amount".
How can I report on JUST the items with differences (where Amount is greater than theOriginal Amount? I know I can "hide" the others, but I don't want to include them in totals.

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts March 26, 2010 17:20 Official comment

  That worked great. Thanks.

• 0
  
  Jet Reports Historic Posts March 23, 2010 15:52

  Hi Gary,
  
  I think you could do this with a calculated filter field like this:
  
  =NL("Rows","Cust. Ledger Entry",,"=IF(NF(,""Amount"")>NF(,""Original Amount""),1,0)","1")
  Does that work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 15, 2010 10:32

  This should be a sticky!
  
  Just what i have been looking for, thanks.