Transferring Grand Total from Pivot when converting widget to Indicator?

Hi all, 

I am using this formula to flag a 1 for every project that is at or under budget. 

SUM(CASE WHEN ([Total budget] - [Total amount]) >= 0 THEN 1 ELSE 0 END)

This works fine as a pivot table since there is an option to display a grand total. However, this widget needs to be an indicator, and I'm noticing that the grand total does not come through when changing from pivot to indicator. Instead, the Indicator total is displayed as "1". 

Choosing the option "Running sum by category" also displays a 1.

Is there a way around this?

Thanks