Ah, didn't need the second WHEN. Try: `CASE WHEN N...
# suiteanalyticsj
jcribb
10/29/2018, 10:18 AMAh, didn't need the second WHEN. Try:
CASE WHEN NVL({estimatedwork},1) != 0 AND NVL(TO_NUMBER({custeventcustevent_initial_cost}),1) != 0 THEN ({actualwork} / NVL({estimatedwork},1) * NVL(TO_NUMBER({custeventcustevent_initial_cost}),1)) ELSE NULL END