How can I set a calculated decimal field to NULL in graphical editor?

[Former Member]

I am calculating a decimal field in the graphical editor (calculation view) and need to set the calculated value to NULL under certain conditinos

e.g.   if(item_shipped_complete,delivery_date - creation_date,NULL)

I was successfull setting dates to null with null(date) but don't know how to set a decimal field to null.

[former_member182779]

A decimal field will expect a number...so only chance is to set it to 0.00 (depending on your number of decimals)...

Greetings,

Blag.