Calculating Custom Fields - Dashboards

I'm trying to create a custom "Win rate" for with our opportunities.

To do this, I want to use the opportunities that we won as the numerator and all non-open opportunities as the denominator. 

As such, my formula looks like this

SUM(CASE WHEN "Current State" = 'Win' THEN 1 ELSE 0 END) AS DECIMAL(10,2) / SUM(CASE WHEN "Current State" = 'Win' THEN 1 WHEN "Current State" = 'Abandoned' THEN 1 WHEN "Current State" = 'Lost' THEN 1 WHEN "Current State" = 'Suspended' ELSE 0 END) AS DECIMAL(10,2)

 

The error message displays, but I can't find out what's wrong with it.

Any help is appreciated!

0

Comments

0 comments

Please sign in to leave a comment.