Forum Discussion
Expressions that yield variant data type ERROR
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
2 Replies
Hi,
Try using something like BLANK() or a 0 instead of "" as "" is used with text
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.
