0

Filter

Jet Reports Historic Posts

March 23, 2012 13:42

None

Follow

Hi,

I'm new in here and my English is not that good. Hope you can understand my question ;)
I want to have a list (rows) of customers. I want to filter it in the following way:

I have two fields in navision: Field A, Field B
I need all Customers where A - B <> 0 and A - B >1000.

I don't know how to filter this.

Should be like:

grouped by Field C:

C_____No______Place________B________A-B________A
1_____1234____Germany_____15_______10 ________25
1 _____5678____Germany____ 10_______20 ________30


Hope anyone can help me!!!

Thanks a lot!

• Facebook
• Twitter
• LinkedIn

6 comments

• 
  Jet Reports Historic Posts May 03, 2012 14:37 Official comment

  Hello Hughes,
  
  I've tried it again without the "comma/decimal thing" using "NUMMER&<1&<>0|>1000" and this works. :D
  
  Using "NUMBER&>1000|0,01" showed all customers where field A - field B >1000. But those with 0,01 were left. I've tried 0.01 as well.
  But sometimes I miss the forest for the trees, so maybe your filter is right. Must take a break now!!! Two much Jet per day drives me mad!! :x ;)
  
  Thanks a lot for your help!!! :D

• 0
  
  Jet Reports Historic Posts March 26, 2012 16:41

  Hi,
  
  You can do this using a calculated filter. It might look something like this:
  
  =NL("Rows","Customer",,"=NF(,""Field A"")-NF(,""Field B"")","NUMBER&<>0&>1000")
  Does that do what you are looking for?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts April 27, 2012 08:49

  Hi,
  
  now I had some time left to try your formula. It works great. Thank you!
  
  How do I have to change the filter "NUMBER&<>0&>1000" so that I get those customers where Field A - Field B = 0,01, too? I don't know how to add this to the filter.
  
  Thanks a lot!!!!

• 0
  
  Jet Reports Historic Posts May 01, 2012 15:34

  I'm glad that worked for you! :) So let me see if I can understand what you want to add. You want to see records where Field A - Field B is greater than 1000 and not 0 although I suppose if it's greater than 1000, it will never be 0 so the <>0 part is probably unnecessary anyway. What do you mean by 0,01? Are you in Europe where a comma denotes a decimal point in the US? Sorry I am from the US so I just want to clarify. Do you want to see values where either it's greater than 1000 OR it's 0.01? Just trying to understand what you want.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts May 02, 2012 08:43

  Hi,
  
  sorry… I've already seen that your from the US but didn't thought about that. :)
  
  Yes, that is exactly what I need.
  Field A - Field B shoulb be either >1000 OR =0.01
  
  I've tried …"NUMBER&0.01|>1000" and …"NUMBER&0.01&>1000"
  but that did not work.
  
  Regards

• 0
  
  Jet Reports Historic Posts May 02, 2012 15:00

  Hello again,
  
  So I've tried an example with the filter "NUMBER&>1000|0.01" (actually slightly different since my data is different but the same principle) and it worked ok for me. Of course for you, I would guess you would need "NUMBER&>1000|0,01" so maybe the comma/decimal is the problem? If that doesn't work, can you describe how it is failing (as in which values are being included or left out which shouldn't be)?
  
  Regards,
  Hughes