Forum Discussion

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
8 years ago
Solved

Expression that yields variant data type with IF statement?

I used an if statement for a calculated column with no problem if my TRUE variable was fixed example: IsInventry = if(LComment[FileNo]=7,"True",""   If I use a variable as the TRUE  example: IsIn...
  • v-jiascu-msft's avatar
    8 years ago

    Hi unclejemima,

     

    Please try to replace the "" with BLANK(). 

     

    Best Regards,

    Dale