CV Totals In (SUM_CASH_VAL nullable is "Y") ->
Modify (handle nulls here) -> (SUM_CASH_VAL nullable is "N") ->
out rec
Handle_Null Generating Fatal Error
Moderators: chulett, rschirm, roy
Pls explain
Yes, Thats how its setup. I am not sure what u r trying to say, pls explain.
Gary
"A journey of a thousand miles, begins with one step"
"A journey of a thousand miles, begins with one step"
Handle_Null Syntax
Thanks a lot Dude. That resolved it.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.
Gary
"A journey of a thousand miles, begins with one step"
"A journey of a thousand miles, begins with one step"