Calculation Explorer Action
Event Function: Calculation Explorer
Use this function to launch the Calculation Explorer window to break down the result of a given calculation into the various balances involved. The full functionality of the Explorer window is available, so clients may drill down on a supporting balance to view more information or even launch the applicable automatic document in Working Papers.
This event is particularly useful for allowing staff to access the Calculation Explorer as a reference tool while in Form mode.
Using the Events tab
| Under | Enter | Example |
|---|---|---|
|
Run Skip Condition |
If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed. |
C5=1 |
|
Calculation |
A calculation to be explored, or a cell number. |
ACT("YR0","100") or C56 |
|
Show Only Results |
A choice as to whether the Calculation Explorer should show only the resulting balance of the calculation or the full exploratory breakdown of the balance. |
No |
Syntax (if entering it in the Equation bar)
ACTION("CalcExplorer", expr1, expr2)
Where
expr1 = the calculation or cell reference to be explored
expr2 = the option selected in the Show Only Results field
How the example will appear in the Equation bar
If a cell is referenced
ACTION("CalcExplorer",C41,"Yes")
or, if an equation is entered directly
ACTION("CalcExplorer",MAP("YR0","115"),"No")
or, if a skip condition is included
ACTION(iif(C16=1,"","CalcExplorer"),C95,"Yes")
