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.

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
Looking for the latest Community solutions? Please visit our accepted solutions board here!