0

Odds or Evens

Jet Reports Historic Posts

February 08, 2017 23:05

None

Follow

How do I create an NL Rows function that only lists odd or even numbers? NAV or Datawarehouse datasources.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts February 08, 2017 23:37

  Hello -
  
  Simplest method would be to list all numbers and then use conditional hiding (https://jetsupport.jetreports.com/hc/en-us/articles/218953738) to hide those you do not want to see.
  
  If you must filter out the odds or evens, you could use this method:
  
  odds:
  
  =NL("Rows","table_name","field_name","=MOD(NF(,""field_name""),2)","1")
  evens:
  
  =NL("Rows","table_name","field_name","=MOD(NF(,""field_name""),2)","0")
  
  This method works for fully numeric (not alphanumeric) values.