Re: Should I check if value is blank or blank()

Anonymous · ‎03-23-2021

If I want to avoid returning blanks... and I have a measure, like:

Revenue YTD:=
VAR RE= [Revenue YTD (Formatted)]
RETURN
IF(RE=BLANK(), --or RE=BLANK?!
0,
RE)

In the IF, should I check if RE=BLANK() or RE=BLANK ?

Pragati11 · ‎03-23-2021

HI @Anonymous ,

You need to check - IF RE=BLANK()

Thanks,

Pragati

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Should I check if value is blank or blank()