Using Formula Results in Other Formulas
I'm a fan of the new formula features, but I've hit a limitation straightaway with it:
- Our revenue is in the form of commission and from suppliers, and fees charged direct to customers. We also pay away some of that commission to third party consultants.
So our total revenue looks like this: - 1) Gross commission
- 2) Consultant pay-away
- 3) Net commission (would like to auto-calculate this as 1 - 2)
- 4) Direct fee
- 5) Total income (currently auto-calculating this as 3 + 4)
It works fine for me to use a formula on 5, to make it show 3+4.
The problem is also want to use a formula to auto-calculate 3, from 1 - 2, but I can't do that because 3 is an input field in another formula.
Is there anyway this feature can be improved, so a field that is calculated using a formula, can itself be an input field on another formula?
Tagged:
0
Answers
-
Not the cleanest solution, but one option is to copy the value of 3 into a custom field using workflow automation when the formula field updates. Then, use that custom field in the formula for 5.
1
