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")

Related Topics