False Grand Total

Hello everyone!

I have a table that shows me the actuals vs budget1 and the actuals vs budget2 and this at item group level.

I added the grand total for the table and somehow I get a right arithmetic average for the first measure and a SUM for the second measure.

The measures are based on the same calculation:

• Divide (Actuals, Budget1)
• Divide (Actuals, Budget2)

Where is my mistake?