Table card percentages

ggountanis
ggountanis Member
in Beast Mode

I'm working on a table card and I can't get the percent of total. I've tried a lot of things and I can't get the percent of total to come out. I have 193 total. Does anyone have any ideas?

image.png

Answers

  • RobSomers
    RobSomers Coach

    @ggountanis You'll need to use a FIXED() function to get the total of all the categories combined:

    SUM(1)/SUM(SUM(1)FIXED()) -This assumes that your data is at the employee level

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • GrantSmith
    GrantSmith Coach

    Agree with @RobSomers . Fixed functions are great for this use case. You can find more information on them here with several examples.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories