You can try this: `CASE WHEN NVL({estimatedwork},1...
# suiteanalyticsj
jcribb
10/29/2018, 10:03 AMYou can try this:
CASE WHEN NVL({estimatedwork},1) != 0 AND WHEN NVL(TO_NUMBER({custeventcustevent_initial_cost}),1) != 0 THEN ({actualwork} / NVL({estimatedwork},1) * NVL(TO_NUMBER({custeventcustevent_initial_cost}),1)) ELSE NULL END