Expressions that yield variant data type ERROR

[WJ876400]

Hi

I keep getting the below error when adding a column. The YEARCHECK is a decimal number and CURRENT OTJ (%) is a decimal number. How do I solve this issue

many thanks

[V-pazhen-msft]

@WJ876400 

It is because the true statement [CURRENT OJT(%)] column is a Numerical column, and the false statement " " returns a Text column, you can reply "" with BLANK().

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

Try using something like BLANK() or a 0 instead of "" as "" is used with text