Expression that yields variant data type with IF statement?

[unclejemima]

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: IsInventry = if(LComment[FileNo]=7,LComment[RecordNo],""

I get the error Expression that yields variant data type

Is there any way around this?

[v-jiascu-msft · Accepted solution]

Hi @unclejemima,

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

Best Regards,

Dale

[unclejemima]

Fantastic. That works great!