Hi,
I have a checkbox attribute (Customized Transaction Body level, Type: Checkbox) on Sales Order in NS. Based on the value of this attribute, another RA level attribute (Customized Transaction Line level, Type: Decimal) on Revenue Arrangement needs to derive its value. So when I put the below formula, I receive an error while running update RA
CASE WHEN {custbody_so_flag} = true THEN '0.20' ELSE 1 END
Error while running update RA - You entered "ERROR: Invalid Expression" into a field where a numeric value was expected. Please go back and change this value to a number.
So far, I have tried below Case expressions:
CASE WHEN {custbody_so_flag} = 'true' THEN '0.20' ELSE 1 END
CASE WHEN {custbody_so_flag} = true THEN 0.20 ELSE 1 END
CASE WHEN {custbody_so_flag} = 'Y' THEN 0.20 ELSE 1 END
Can you please help me in understanding what is wrong with my simple formula?
Thanks!