Forum Discussion
WJ876400
Helper IV
Helper IVExpressions 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
GordonliljSolution Sage
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.
