Use the Result Finder dialog - Solve mode tab to solve for the dollar amount for one or two input (data entry) fields in order to achieve a desired result in a particular calculated field.
To open this dialog, choose Tools > Result Finder. In the Result Finder - Column Selection dialog, choose an alternative and year and click OK. In the Result Finder dialog, click the Solve mode tab.
Note: You can also use the Result Finder to see the effect of the variation of one or two input fields on up to six calculated fields by clicking the Step mode tab.
Fields & buttons
Variable Fields group box
Use this group box to indicate which data entry field(s) should be varied.
Target group box
Use this group box to identify the calculated field and target amount.
Watch fields group box
Select up to five calculated fields to view how their amounts would change.
Buttons
Was this article helpful?
Thank you for the feedback!