Transferring Grand Total from Pivot when converting widget to Indicator?

[maddymorningsta]

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

[ssoltz · Accepted solution]

Try this...

Assuming that Project ID is a unique identifying field available...

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

[DRay]

Hello @maddymorningsta ,

I wanted to follow up to see if the solution offered by @ssoltz worked for you

If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.