# Success rate calculation

I'm trying to work out the success rate of applications submitted, attached is a basic flow diagram of how this calculation works.

I have setup an ETL which filters out any withdrawn applications and separates the approved and refused applications.

Is there a way that I can sum the values of Approved Applications and Approved/Refused applications? I could then do a divide calculation to get the success rate.

Tagged:

• You could utilize a formula tile or a beast mode (if you want to apply filtering dynamically to your calculation) to calculate it:

````Approved` / (`Approved` + `Refused`)
```
**Did this solve your problem? Accept it as a solution!**
• @louiswatson As you have it set up now, if you haven't already, you'll need to add a column to each branch named something like 'Type' that identifies 'Refused' for the Refused branch and 'Approved' for the Approved branch and then append the two. Then do the following:

SUM(case when 'Type' = 'Approved' then 1 else 0 end)/SUM(1)

Also, if you're able to, I would suggest creating the 'Type' tag in a formula tile and then you don't need to have the split and then append. It'll simplify things and do it in just one step instead of multiple.

**Did this solve your problem? Accept it as a solution!**

• Thankyou both, @RobSomers I tried the formula but the value didn't come back as expected. I have used a Group By after adding the 'Type' column.

What would be the best way to work out Approved/Approved and Refused?

Many thanks

• @louiswatson You would use the formula I gave you as a beast mode in a card if the data was at an application grain. You can use a Rank & Window tile to get the totals after the Group By tile and join it to your groups and do the calculation from there, or you can use the FIXED function in a formula tile to do the calculation all in one go.

https://domohelp.domo.com/hc/en-us/articles/4408174643607-Beast-Mode-FIXED-Functions