In the Specify calculation dialog, did you clear the check box named "do not evaluate if all referenced fields are empty"?
Yes I did.
In what table is CAPBalance defined?
Can you copy and paste the exact expression for that field here?
Okay, here's the related information. CapBalance is in the WorkOrders table.
I'm getting these expressions from what you have posted:
If ( DRF::CapTotal2 = 0 ; 0 ; DRF::SRCO_Captotal - ProjectTotal )
CapTotal2: Total of Cap via DRF table occurrence
SRCO_Captotal: Total of SRCO_Cap via DRF table occurrence
If ( IsEmpty ( SRCO ) ; Cap ; 0 )
and the "do not evaluate...." check box is still selected on this field. Thus, if SRCO and Cap are empty, this field will be empty.
Going bac to your first post:
if there are no records in the WorkOrders::WO field, there is no WorkOrders::WOTotal and the calculation fails
I'm afraid that statement has me confused. If there is no record in WorkOrders, CapBalance does not exist as it is defined in WorkOrders. So I'm not sure what you mean here.
Sorry it took so long to respond. I figured a simpler way to deal with this problem. It's not possible, or it's difficult to get the application to figure out what the correct Cap amount should be so I created a field and manually entered the correct Cap. I used the new field in my calculation and it works fine. Thanks for your help.
Yet what you wanted to do should work and quite smoothly once the needed work is done via relationships and calcualtions.
Manually entering the value raises the possibility of data entry errors that are fully avoidable.