IF STATEMENT TO KNOW IF REPORT LINK IS POPULATED

  • 0
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
  • (Edited)
I am wanting to write an IF statement to tell me if a report link has any data in it. It tried this IF statement but it does not change

IF([Scheduled Job]=null, "Scheduled", "Not Scheduled")

Basically the assumption is if there is data in the report link Related Scheduled Job then it is scheduled.

Thanks for the help.
Photo of Jason Beaver

Jason Beaver

  • 270 Points 250 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
I think you mean to say 'Reference field'. 

If thats the case, numeric reference fields will have a null value, but act like a "0" by default.

You can change the field properties for the reference field, or do what I do and just change the logic in the formula (faster for me)

">0" rather than "=null"

IF([Related Scheduled Job]>0, "Scheduled", "Not Scheduled")