6 Replies Latest reply on Jul 22, 2016 3:24 AM by khalid norat

    Overall Percentage Calc

    Tony Ball

      Hi All,

       

      I wondered if you could help with this one?

       

      I've built a dashboard which does some Yes/No checks on some computer devices at work. I've currently got 4 checks running which you can see in screenshot below.

       

      I have been trying to roll up the percentages from these 4 checks to produce another panel which would display an overall heath in a percentage score.

       

      So for example in the Red panels I have percentage scores of 28.06, 9.09, 33.40 and 12.17. I know that I just need to add these totals up and divide by 4 to get to my Overall health percentage - however I seem to be having a tough time making a calculated field to do this. Perhaps it is blindingly obvious and I'm just not seeing it? It would be great if someone can help?