Tableau Calculation and Number Accuracy Audit
Check calculations against the source and each other.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Audit the calculations in a Tableau workbook. Calculated fields with formulas: [CALCULATIONS]. Numbers shown on dashboards: [SHOWN_NUMBERS]. Source numbers: [SOURCE_NUMBERS]. Filters in use: [FILTERS]. Choose five numbers to recalculate by risk: those used in decisions, those with LOD expressions, those with percent of total, and any that look odd. For each write the formula in words, the filter context where it is shown, the hand calculation from the source numbers, and the result. Check aggregation level, filter order of operations (a dimension filter does not affect a FIXED expression), null handling, averages of averages, percent of total with the wrong scope, and date handling; compare totals across sheets and with the source. Separate confirmed errors from suspected ones, listing what extra data would settle each. Return a table (Number, Shown, Recalculated, Difference, Cause, Fix) and a regression checklist of numbers to recheck after any workbook change, with an owner. Mark function behaviours you cannot verify [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.