CASE WHEN {custentity1} > .17 THEN 18 ELSE 0 EN...
# generalp
Patrick Olson
08/02/2022, 3:16 PMCASE WHEN {custentity1} > .17 THEN 18 ELSE 0 END
k
Kenjamin
08/02/2022, 3:18 PMwhat formula type did you use?
p
Patrick Olson
08/02/2022, 3:18 PMtext
k
Kenjamin
08/02/2022, 3:21 PMthis is so weird. I have it set to formula text and the code is CASE WHEN {custbody_appliance_gross_profit}) > .1799 THEN 0 ELSE '🔞' END
Kenjamin
08/02/2022, 3:21 PMbut it still shows invalid expression
Kenjamin
08/02/2022, 3:22 PMeven tried CASE WHEN {custbody_appliance_gross_profit}) > .1799 THEN 0 ELSE 'UNDER 18' END
Kenjamin
08/02/2022, 3:26 PMi finally got it
Kenjamin
08/02/2022, 3:27 PMdid CASE WHEN TO_NUMBER({custbody_appliance_gross_profit}) < .18 THEN 'UNDER 18' END
✅ 1
p
Patrick Olson
08/02/2022, 3:29 PMI'm not an expert on this so I don't have a reason why, but it seems if you mix output types it throws an error.
Try putting '0' instead of 0
Patrick Olson
08/02/2022, 3:30 PMWhen you had the else in the formula you were outputting a number else a string. Seems like NetSuite/SQL doesn't like that
k
Kenjamin
08/02/2022, 3:58 PMoh, that makes sense. thanks for helping me troubleshoot through the issue
3 Views