Table card percentages

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?

Answers

  • @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!**

  • 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!**