DIFFERENCE = SUM(MODELED_ALLOWED) - SUM(ALLOWED)
%_DIFFERENCE = DIFFERENCE / SUM(ALLOWED)
thanks for the reply. Tableau doesn't like this:
DIFFERENCE = SUM(MODELED_ALLOWED) - SUM(ALLOWED).
The DIFFERENCE pill goes red (even tho this calculation is accepted) and the whole sheet goes blank.
I appreciate the help tho! Thanks,
Pl keep Cursor over the Red and see what it is saying
You have one of the calculation which is already aggregated. From this point, I would need a workbook to look into .