Hi there forum

I'm building a grant tracking database for a non-profit organisation and have a field called "allocation balance" that looks at the "amount" and minuses line item expenses in the Expenditure Sub File (portal).

Calculation "Total amount - Sum ( Expenditure Sub File::Amount )"

I may very well have to attach a sample of the database.

Where the "amount" is $275.15, I allocate this full amount in the Expenditure Sub File and the "allocation balance" reads -$0.00 instead of just $0.00.

Any thoughts and contributions welcomed.

Kind regards

Tim

What do you see when you click into the field?

Hi Comment

It's a calculated field that takes what value is in the "amount" field, minuses values in the sub-file (bit like an invoice systems line items).

That way it shows how much money has not been allocated.

Thanks for your reply.

Tim

What do you see when you click into the field?

When I click into the field it says "-2.0e-14" minus quotes.

Thanks

Tim

Well, then the total amount does not EXACTLY equal the sum of the expenses, and the "-$0.00" you see indicates a (very small) negative number rounded to zero for display purposes.

I don't think you need to worry about this, but if it bothers you, change the calculation to =

Round ( Total amount - Sum ( Expenditure Sub File::Amount ) ; 2 )

Are either the total or the expense calculated?

Fantastic, your a genius, comment!

Works perfectly and addresses other parts of my database I could you a similar calculation.

Many thanks, comment

Tim

I am still curious about the answer to my question: are either the total or the expense calculated?