Solved
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...
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)
