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

BenWalkerRH

Posted 1 year ago·Last reply 11 months ago

6 comments

DRay

·11 months ago

Hi BenWalkerRHBenWalkerRH,

Do you still need help with this?

DRay

·11 months ago

Hi BenWalkerRH,

Do you still need help with this?

BenWalkerRH

OP1 year ago

Hi MikeGre ,

Option A gave me a result of 100%

Where in the formula would I use option B?

Michalis Gregoriou

·1 year ago

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

OP1 year ago · Edited

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.

Michalis Gregoriou

·1 year ago

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!