Is it possible to run a calculated field of amounts within the same field, but they have different category names?
I.e.
Field 1 = Rate
Field 2 = Basis
Data
Basis = "CAN", "US"
Rate = "10", "20"
How can I have a calculated field that would be capable of distinguishing:
1. Rate (CAN) - Rate(US)
= 10 - 20 = -10 (-10 is the calculated field)
Thank you
It's possible to add a calculated field that deducts one field from another. In the attached sample Difference column is the sum of Gross Amount minus Open Amount. The screen image shows the calculated field setup.
Last edited by tuph; 11-08-2016 at 09:51 PM. Reason: Oops! attached image didn't work. Hopefully the JPG will.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks