Skip to content

    • Beast Mode

    Beast Mode

    Percentage calculation using beastmode

    Member
    in Beast Mode

    Hello Everyone, Please help. I am getting syntax error when I'm trying to rewrite this formula in beastmode. Below screenshot of my formula how it looks like in our database that I want to re-create using beastmode:

    Screenshot 2024-11-20 at 1.10.55 PM.png

    I want to get a Loss Ratio percentage between 0 to 100. and results should have a percentage sign with 2 decimal. For example: 86.99%

    Thank you.

    Best Answer

    • Coach
      Answer ✓

      @Jez Your beast mode should look like formula below. 

      1. SUM(IFNULL(`Reserve_Amt`,0)) / SUM(IFNULL(`Premium_Written`,0))

      Instead of multiplying by 100 and adding the percent sign in the calculation, I recommend using the native Percentage formatting once the calculation is added to the card.

      image.png

      If this does not answer your question, then please provide a screenshot of your Beast Mode within Domo, as well as the error message.

    Answers

    • Coach
      Answer ✓

      @Jez Your beast mode should look like formula below. 

      1. SUM(IFNULL(`Reserve_Amt`,0)) / SUM(IFNULL(`Premium_Written`,0))

      Instead of multiplying by 100 and adding the percent sign in the calculation, I recommend using the native Percentage formatting once the calculation is added to the card.

      image.png

      If this does not answer your question, then please provide a screenshot of your Beast Mode within Domo, as well as the error message.

    • Member

      This works. Thank you so much

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories