0

NF & @@

Jet Reports Historic Posts

July 16, 2010 19:29

None

Follow

I'm using the following formula

=NF($L14,"Shipment Date")

where L14 is sometimes blank. I've unsuccessfully tried writting the formula like =NF("@@"&$L14,"Shipment Date") to prevent getting error messages. How can I write an NF formula to allow for blank values?

Thanks

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 29, 2010 18:55

  Hi there,
  
  You shouldn't have to use the "@@" when using NF() functions. The only reason your NF() functions should ever get errors is because the NL() record key they are linked to (L14) has an error. The NL() is where you will need to deal with the blank value. Does this make sense?

• 1
  
  Jet Reports Historic Posts August 02, 2010 20:37

  If you want your NF formula to check your NL result before returning a result, you can use the "if()" formula in Excel. I have used this on a few of my reports. Use the following:
  
  =if($L14="","",NF($L14,"Shipment Date"))
  
  Let me know if this gives you what you're looking for.
  
  Thanks,
  
  Scott