jcribb
10/29/2018, 10:43 AMNULLIF({custeventcustevent_initial_cost},0)
and {custeventcustevent_initial_cost} is 0, then it will return null. NVL checks to see if the value is already null and then replaces it with your second value NVL({custeventcustevent_initial_cost},0) so if {custeventcustevent_initial_cost} is null, then it will return 0, if not the value of {custeventcustevent_initial_cost} is returned