I have financial data with Actual and Budget $s. I need to create a Variance and Variance % calculation.

I created the Variance calculation as an aggregate formula:

Var. = SUM(Budget - Actual)

I then tried to create a Var. % which using the aggregate forumula "Var.".

Var. % = SUM(Var.) / SUM(Budget).

I get an error. See attached screenshot.

Thanks

Sunil