How can I calculate the percentage that a beast mode result is of a column set to 'count'?

Reply
Highlighted
White Belt

How can I calculate the percentage that a beast mode result is of a column set to 'count'?

Hi, this might be simple for some of you but i'm really struggling! 

Below is a table I have created. Columns 1 and 2 are using the 'count' functionality whilst column 3 is a beast mode that subtracts column 2 from column1. What I need to do is create a beast mode calculation that will indicate what percentage the outstanding value is of column 1. Does anybody know how? Big thanks in advance. 

 

Screenshot 2019-02-07 at 12.32.56.png


Accepted Solutions
Black Belt

Re: How can I calculate the percentage that a beast mode result is of a column set to 'count'?

Give this a a shot:

(COUNT(`Works Sent`)-COUNT(`Works Registered`))
/
COUNT(`Works Sent`)

Then it's just down to formatting the new beast mode to be a Percentage. 

 

Let me know if that wasn't what you were looking for,

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.


All Replies
Black Belt

Re: How can I calculate the percentage that a beast mode result is of a column set to 'count'?

Give this a a shot:

(COUNT(`Works Sent`)-COUNT(`Works Registered`))
/
COUNT(`Works Sent`)

Then it's just down to formatting the new beast mode to be a Percentage. 

 

Let me know if that wasn't what you were looking for,

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

White Belt

Re: How can I calculate the percentage that a beast mode result is of a column set to 'count'?

That works, thankyou very much!

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!