Summing (Null values)

[Senseial]

Hello ALl

I have a problem with summing two fields in the formula.
But the problem is one or the other fields can be NULL. I am checking for null and I use IIF to see it it is than 0 else put the field value. Than I sum the two and I get no result. What am I doing wrong.

1.
IIF (IsNull({v_rep_inv_req_sku.QUANTITY_GOOD}),0,{v_rep_inv_req_sku.QUANTITY_GOOD})

2.
IIF (IsNUll({v_rep_inv_req_sku.QUANTITY_DAMAGED}),0,{v_rep_inv_req_sku.QUANTITY_DAMAGED})

and than var1 + var2


Thanks a lot

 

[lupins46]

Can you post the actual code you are using.

 

[synapsevampire]

Try:

@Formula1
IF IsNull({v_rep_inv_req_sku.QUANTITY_GOOD}) then
0
else
{v_rep_inv_req_sku.QUANTITY_GOOD}

@Formula2
IF IsNUll({v_rep_inv_req_sku.QUANTITY_DAMAGED}) then
0
else
{v_rep_inv_req_sku.QUANTITY_DAMAGED}

@formula3
{@formula1}+{@formula2}

-k

 

[Senseial]

Thank. I did that the minute I posted my question. Not sure why IIF does not work and IF works.
Alex