Table card percentages

ggountanis Member

March 2023 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?

0

Answers

• 

  RobSomers Coach

  March 2023

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

  3
• 

  GrantSmith Coach

  March 2023

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

  0