And here it is with 0's instead of 1's: `CASE WHEN...
# suiteanalyticsj
jcribb
10/29/2018, 10:22 AMAnd here it is with 0's instead of 1's:
CASE WHEN NVL({estimatedwork},0) != 0 AND NVL(TO_NUMBER({custeventcustevent_initial_cost}),0) != 0 THEN ({actualwork} / NVL({estimatedwork},0) * NVL(TO_NUMBER({custeventcustevent_initial_cost}),0)) ELSE NULL END