BenWalkerRH
09-01-2025Data Storage
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