DSXchange

CV Totals In (SUM_CASH_VAL nullable is "Y") ->

Modify (handle nulls here) -> (SUM_CASH_VAL nullable is "N") ->

out rec

Yes, Thats how its setup. I am not sure what u r trying to say, pls explain.

Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.

Ronetlds wrote:Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.

Thanks a lot Dude. That resolved it.