Skip to Content
0
Former Member
May 17, 2011 at 10:03 AM

Formula which includes null values

34 Views

Hi,

I am struggling to create a formula which caters for null values.

My formula contains IF( ZTAG2 > 0, ZTAG2, ZTAG1 ), but ZTAG2 or ZTAG1 can be null which is causing the result to be null. I need the result to be 0.

Is there a way that I can default ZTAG2 and ZTAG1 to have a zero value? They are both set up as numeric key figures.

Thanks