0

NL(Count) with"IF"

Jet Reports Historic Posts

December 07, 2010 16:02

None

Follow

Hi,

I know, that using "IF" with "=NL(Rows)" is working, when using the right combination like =NL("rows";IF (B2=XYZ)….

But does this also works with =NL("Count";IF…) and =NL("sum";IF…)……….. ?

Does anyon know?

THX for helping..

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts December 07, 2010 17:36

  Hi,
  
  The only reason you need to use the IF function with the table parameter in an NL(Rows) is because it is a replicator and it won't replicate if you put the IF(B2=XYZ,NL(Rows…)). However, with NL(Sum) and NL(Count), there is no replication, so you can just put them inside the IF statement like IF(B2=XYZ,NL(Sum,…),0).
  
  Does that answer your question?
  
  Regards,
  Hughes