Field calculation displaying incorrectly

[topaznz]

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

[comment]

What do you see when you click into the field?

[topaznz]

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

[comment]

What do you see when you click into the field?

[topaznz]

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

Thanks

Tim

[comment]

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?

[topaznz]

Fantastic, your a genius, comment!

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

Many thanks, comment

Tim

[comment]

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