Forum Discussion

Kayla2501's avatar
Kayla2501
Regular Visitor
4 years ago
Solved

IF function HELP

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's avatar
    amitchandak
    4 years ago

    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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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