Percentage in formulas | Help and How-To

BenWalkerRH · 2025-09-01T13:58:24.271000Z

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,321FALSE = 876TRUE = 564 Any help would be appreciated

MoreDiscussions

Percentage in formulas | Help and How-To | Sisense Community