A Formula is Incorrect

Tabular has predefined formulas. If in some cases when the formula might not seem right, please do the steps below:

1. Check drill down to make sure all data points are correct or to identify any issues.

2. If the above step is fine, then try to replace the formula to restore it.

• Click Subtotals/Interaction under Validation section of the ribbon.

• Option are available for replacing formula of a selected cell or selected QRT.

• Click Replace Formula.

• A confirmation message appear that formula has been replaced.

Additional information, click here.