Skip to content

    • Beast Mode

    Beast Mode

    Ratio Formula

    Member
    in Beast Mode

    Hi! I need help to use the beast mode function. I have the following columns:

    Name, Ref #, Paid Amount, Savings Amount and Bill Amount.

    I want to get the Ratio of Each Name using this formula:

    Paid Amount + Savings Amount / Bill Amount

    Screenshot 2024-11-20 at 10.40.09 AM.png

    Thank you!

    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

    Best Answers

    • Coach
      edited November 2024 Answer ✓

      You would create a beast mode with the following code:

      (SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`)

      Then you'd create a table card with the first column being the Name and the second column being the beast mode you create.

      Here is a video on how to create a beast mode:

      https://youtu.be/h6SQR_H9OsY

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

      Use add beast mode to create a new calculation using a formula like

      1. ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`

      Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly.

      Also make sure you have no null or zero values in Bill Amount. Otherwise you will get division errors.

      1. CASE 
      2.     WHEN `Bill Amount` = 0 THEN NULL
      3.     ELSE ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
      4. END

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    Answers

    • Coach
      edited November 2024 Answer ✓

      You would create a beast mode with the following code:

      (SUM(`Paid Amount`) + SUM(`Savings Amount`)) / SUM(`Bill Amount`)

      Then you'd create a table card with the first column being the Name and the second column being the beast mode you create.

      Here is a video on how to create a beast mode:

      https://youtu.be/h6SQR_H9OsY

      If I solved your problem, please select "yes" above

    • Coach
      Answer ✓

      Use add beast mode to create a new calculation using a formula like

      1. ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`

      Domo uses back ticks to enclose field names. Name it something like "Ratio". Save it and make sure it validates properly.

      Also make sure you have no null or zero values in Bill Amount. Otherwise you will get division errors.

      1. CASE 
      2.     WHEN `Bill Amount` = 0 THEN NULL
      3.     ELSE ( `Paid Amount` + `Savings Amount` ) / `Bill Amount`
      4. END

      ** Was this post helpful? Click Agree or Like below. **
      ** Did this solve your problem? Accept it as a solution! **

    • Member

      Awesome example and explanation!

    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