User fills in either of two fields, can QuickBase calculate the other?
We sell services to clients for an hourly rate. The workers who perform the services then get paid either a percentage of that rate, or a flat amount [yes, I know the flat rate is also a percentage of the total, but Accounting wants to be able to enter it as a flat rate because of other factors].
So if I have two fields - Percentage to Pay and Amount to Pay, what they want is to be able to enter either one, and have QuickBase calculate the other.
For example, the hourly rate is $110. They want to enter 65% in the Percentage to Pay field, and have the amount calculate as $71.50.
If, on the other hand, the pay to the worker is defined as $71.50 an hour, then they want to enter $71.50 in the Amount to Pay field, and have the percentage calculate as 65%.
Is there a way to allow this?
------------------------------
Charlotte Morin
------------------------------