Remaining Funds = Original Fund Amount - Fund Amount Used
Simple equation that is the foundation for the one below. The equation works in my form, but not when one subtotal is Null (no entry due to no cost spenditure). The equation must be able to still calculate the Remaining Funds although a $0 cost may be included in the equation.
=[Total_MIPR].[Form]![SumOfMIPR]-[Mainpart2 subform2].[Form]![Total3]-[Total_CAP_POL].[Form]![SumOfCAP]-[Total_CAS_SUPPLY].[Form]![SumOfCAS]
EXAMPLE: 500 - 200 - 50 - 100 = 150
500 - 200 - 0 - 100 = doesn't work due to a null, blank, 0 cost subtotal.
Simple equation that is the foundation for the one below. The equation works in my form, but not when one subtotal is Null (no entry due to no cost spenditure). The equation must be able to still calculate the Remaining Funds although a $0 cost may be included in the equation.
=[Total_MIPR].[Form]![SumOfMIPR]-[Mainpart2 subform2].[Form]![Total3]-[Total_CAP_POL].[Form]![SumOfCAP]-[Total_CAS_SUPPLY].[Form]![SumOfCAS]
EXAMPLE: 500 - 200 - 50 - 100 = 150
500 - 200 - 0 - 100 = doesn't work due to a null, blank, 0 cost subtotal.
