Simple Math Calculations

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Marie_(Guest)
Posts: 11
Joined: Tue Oct 10, 2017 12:44 pm

Simple Math Calculations

Post by Marie_(Guest) » Mon Jun 08, 2009 5:24 pm

Is it out of the realm of possibilities that R&R be able to subtract 1 field from another? I thought this would be a fairly simple request, but it seems to be impossible. I have a calculated field for the amount due on a specific date, now I would like to see the remaining balance by subtracting the amount due on that date from the original invoice dollar amount. Am I missing the language that says: =Sum(fieldA-fieldB)

Chris_Hibbert_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Simple Math Calculations

Post by Chris_Hibbert_(Guest) » Tue Jun 09, 2009 8:16 am

Just make a calculated field that says:__FieldA-FieldB__The SUM function is not needed. Now if the data from A and B don^t both appear in the same record you have to handle it differently.__Hope this helps.

Post Reply