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

Reply
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.

Highlighted
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
Looking for the latest Dojo Community solutions? Click on the "NEW SOLUTIONS' widget title or go to https://dojo.domo.com/solutions Click here!