Percentage calculation using beastmode

Jez · 2024-11-20T19:05:45+00:00

There was an error rendering this rich post.

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:

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.

Find more posts tagged with

Accepted answers

MichelleH

@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.

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

All comments

MichelleH

@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.

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

This works. Thank you so much