Forum Discussion

maddymorningsta's avatar
maddymorningsta
Data Storage
02-16-2024
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...
Customer Service Analytics
dashboards & reporting
  • ssoltz's avatar
    ssoltz
    02-16-2024

    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's avatar
DRay
Admin
03-04-2024

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.