In the formula editor there is a drop down. The default setting is EXCEPTION FOR NULLS

Change that to DEFAULT VALUE FOR NULLS

The other way to handle this is to use formulas for the values or NULL tests in the sum formula

Formula SellPrice

If IsNull({tblSO.sellprice}) then

0

Else

{tblSO.sellprice}

Formula Cost

If IsNull({tblSO.cost}) then

0

Else

{tblSO.cost}

Formula ContractorCost

If IsNull({tblsubcontractor.cost}) then

0

Else

{tblsubcontractor.cost}

Your sum formula changes to

{@SellPrice} - ({@Cost} + {@ContractorCost})

You can also do this in a single formula

Local CurrencyVar total;

If NOT IsNull({tblSO.sellprice}) then

total := total + {tblSO.sellprice};

If NOT IsNull({tblSO.cost}) then

total := total + {tblSO.cost};

If NOT IsNull({tblsubcontractor.cost}) then

total := total + {tblsubcontractor.cost};

Total

mlmcc

Change that to DEFAULT VALUE FOR NULLS

The other way to handle this is to use formulas for the values or NULL tests in the sum formula

Formula SellPrice

If IsNull({tblSO.sellprice}) then

0

Else

{tblSO.sellprice}

Formula Cost

If IsNull({tblSO.cost}) then

0

Else

{tblSO.cost}

Formula ContractorCost

If IsNull({tblsubcontractor.c

0

Else

{tblsubcontractor.cost}

Your sum formula changes to

{@SellPrice} - ({@Cost} + {@ContractorCost})

You can also do this in a single formula

Local CurrencyVar total;

If NOT IsNull({tblSO.sellprice}) then

total := total + {tblSO.sellprice};

If NOT IsNull({tblSO.cost}) then

total := total + {tblSO.cost};

If NOT IsNull({tblsubcontractor.c

total := total + {tblsubcontractor.cost};

Total

mlmcc