0

IIF - What am I doing wrong here?

Jet Reports Historic Posts

January 20, 2012 15:08

None

Follow

the idea is to check $M5 and if not empty count "vendor number" field otherwise is "0". I am sure it is syntax because I am a JET spaz. Not a regular user, sorrry. Thanks for the help!

=IIF($M5 > "0", NL("Count","SF_DATA",,"DataSource=","SF_DATA","Vendor_Number",$M5), "0")

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 20, 2012 17:23

  Hi K,
  
  I think for starters, you need to not quote your zeros. $M5 > "0" will not work if the value in M5 is actually a number and not a string. I think your formula should look something like this:
  
  =IF($M5>0, NL("Count","SF_DATA",,"DataSource=","SF_DATA","Vendor_Number",$M5),0)
  Does that work better?
  
  Regards,
  Hughes