Result Finder - solve mode
Show all hidden content
Use the Result Finder window - Solve mode tab to solve for the dollar amount for one or 2 input (data entry) fields to achieve a desired result in a particular calculated field.
To open this window, select
Tools
, then Result Finder
. In the Result Finder - Column Selection window, select an alternative, a year and then select OK
. In the Result Finder window, select the Solve mode
tab.note
You can also use the Result Finder to see the effect of the variation of one or 2 input fields on up to 6 calculated fields by selecting the Step mode tab.
Fields & buttons
Variable Fields group field
Use this group field to indicate which data entry field should be varied.
Input field
Use this field to select the name of the input (data entry) field that contains the value you would like to modify to achieve a desired dollar amount for a selected calculated field. To run the Result Finder, this field can't be blank.
- If you opened this window while the cursor was in a federal input (data entry) field, the name of that field appears in this field.
- If this field is blank, or to select a different field, select the dropdown arrow or press F4 to view a list of fields to select from. Only federal input (data entry) fields are available to select.
Use Companion field.
Select this checkbox if you would like the Result Finder to solve for a 2nd data entry field amount. (Select the 1st data entry field in the
Input field
description field previous.)If you select this checkbox, the
Companion
field will be displayed, where you can select an additional data entry field to use in the Result Finder's calculations.Companion field
note
This field is only available if you select the
Use Companion Field
checkbox.If you would like the Result Finder to solve for 2 data entry field amounts that correspond with a desired amount for a calculated field, select the
Use Companion Field
checkbox and enter a field name in this field. To enter a name, select the dropdown arrow or F4 to view a list of fields to select from. You can only select data entry fields.After you select a
Companion
field, select an option to indicate whether you want the Result Finder to calculate the correct amount by incrementing the companion field amount in the same or opposite direction as the input field amount. Change in the same increment as the input field previous / Change in the opposite increment (multiply by -1) options.
note
These options are only available if you select the
Use Companion Field
checkbox.Select the
Change in the same increment as the input field above
option if you want the Result Finder to adjust the Companion field amount in the same direction that it will adjust the Input field amount when solving for the result.Select the Change in the opposite increment (multiply by -1) option if you want the Result Finder to adjust the Companion field amount in the opposite direction that it will adjust the Input field amount when solving for the result.
Target group field
Use this group field to identify the calculated field and target amount.
Result field name and amount
Use this field to select the name of the calculated field for which you have in mind a predetermined value. To run the Result Finder, this field can't be blank.
- If you opened this window while the cursor was in a calculated field, the name of that field appears in this field.
- If this field is blank, or to select a different field, select the dropdown arrow or F4 to view a list of fields to select from. Only federal calculated fields are available to select.
After you select a calculated field, enter the desired amount in the
Result Field Amount
field.Watch fields group field
Select up to 5 calculated fields to view how their amounts would change.
Watch fields.
You can select up to 5 federal calculate fields to serve as Watch fields. Select a field by selecting the dropdown arrow or F4 to view a list of fields to select from. Only federal calculated fields are available to select.
Buttons
Start button
Select
Start
to have the Result Finder solve for the dollar amounts for the Input and Companion fields that correspond with the desired value of your selected Result field.You can modify the Input, Companion, and Result fields. Select
Start
any number of times without this affecting the plan itself. Amounts from the Result Finder window won't transfer to your plan until you select Transfer Results
.Transfer results button
Select
Transfer Results
to transfer the amounts displayed next to the Input field and Companion field (if applicable) into the open plan.note
If plan data already exists in the Input or Companion field, the Result Finder will replace it with the new amount. If allocation data already exists in the field, Planner CS will indicate the difference between the old and new amounts in the Allocation window for that field.
Related Content
-
Result Finder
Format:
Article,
1 min read