Percentage calculation using beastmode

Jez
Jez 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

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Jez Your beast mode should look like formula below. 

    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

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Jez Your beast mode should look like formula below. 

    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.

  • Jez
    Jez Member

    This works. Thank you so much

Categories