IF function HELP

[Kayla2501]

Hi All, 

I want to add a new column that is basically if Status date equals current then give the value in confidence factor if not than blank. (current status date is 30 June 2022) 

I have tried this and it doesnt work and not sure why?

[amitchandak · Accepted solution]

@Kayla2501 . Confidence back is numeric, so in place on "" use 0 or blank()

Also, the measure will not work correctly in the calculated column, if you are using one