0

NL(Rows) inside IF-function

Jet Reports Historic Posts

July 31, 2012 12:09

None

Follow

Hi
Does any of you have expirience with using NL(Rows) inside a IF-function. For example: IF(C5=2;NL("Rows";….);"''")

When I put a NL(Rows) in a IF-function, the IF-function works correctly, but if this means that the NL(Rows) should be activated it only returns the first row.

Best,
Annelise

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 31, 2012 15:01 Official comment

  Hi Annelise,
  
  NL(Rows) will not work inside an IF function because of how Jet expands rows functions. However, you can achieve something very similar with something like this:
  
  =NL("Rows";IF(C5=2;"Table";{""});…)
  Does this work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 28, 2012 08:56

  Hi Hughes,
  
  never got back to you…
  
  Thank you - yes it works.
  
  Best,
  Annelise