Forum Discussion

BenWalkerRH's avatar
BenWalkerRH
Data Storage
09-01-2025

Percentage in formulas

Hello!

I'm trying to work out how to get a percentage value in a formaula.
The results are not what I'm expecting so i imagine it's my maths letting me down.. 

The end result needs to be a percentage count of all safeguarding events ever.

What my formula is currently looking like is: 
([# of unique EventUID], [Was the incident a safeguarding?]) / ([# of unique EventUID]) * 100
    With [Was the incident a safeguarding?] being filtered to TRUE. 

This gives me a result of 266%

Base values for objects are:
[# of unique EventUID] = 19,761

[Was the incident a safeguarding?]
N/A = 18,321
FALSE = 876
TRUE = 564

Any help would be appreciated

5 Replies

  • Hi BenWalkerRH​ 

    Try the following: 

    Option A: [# of unique EventUID]/([# of unique EventUID],ALL([Was the incident a safeguarding?]))

    Option B: CONTRIBUTION ([# of unique EventUID])

    Let me know if the above helped you!

    • MikeGre's avatar
      MikeGre
      ETL

      BenWalkerRH​ can you share a bit more information on what type of widget you are trying to build? Is it a pivot? Option B should be the value in your widget I suppose?

      • BenWalkerRH's avatar
        BenWalkerRH
        Data Storage

        MikeGre​ 

        Sure thing!

        Im trying to build a blox widget to show:

        Ring value is going to be essentially the same formula. This is yet to be amended. 
        Percentage is the 266% - this will need to be the total of safeguarding incidents. This is the script which i'm struggling with. 
        And the total number of safeguarding incidents at the top.