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

DannyLewis
DannyLewis Member
in Magic ETL

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

Tagged:

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    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.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    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
    DannyLewis Member

    That works, thankyou very much!

Categories