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

DannyLewis

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. 

 

BlueRooster

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.

BlueRooster

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.

DannyLewis

That works, thankyou very much!