list - Sharepoint calculated column based on other columns #NULL! error -

list - Sharepoint calculated column based on other columns #NULL! error -

i trying add together 2 currency columns in calculated column getting #null! error.

this seems pretty straightforward first time doing in sharepoint.

sharepoint 2010 excel services available.

have create list required columns:

approved value column type = currency

pending value column type = currency

total value column calculated (calculation based on other columns) type = currency formula: =[approved value]+[pending value]

the values in other columns indeed currency, total shows #null! items.

i can't see done incorrectly.

what should looking resolve problem?

try using isblank function check if of value null.

reference: isblank function

list sharepoint calculated-columns