Let's Reconnect, thank you for making 2022 our best year yet.

Dividing Metrics — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content.
Interested in joining? Complete your registration by providing Areas of Interest here.

# Dividing Metrics

14
Views
12
Comments
edited Jan 31, 2020 6:24PM 12 comments

# Summary

I am trying to divide two metrics -- Not working!!

# Content

I am trying to divide two metrics and am not getting the results I need. Can someone help?

The number of Won Opportunities is 19. The number of Closed is 56. I want to show 19/56 = 34%. The two formulas I've tried in the tool are below with the result I'm getting.

FILTER ("Pipeline Facts"."# of Opportunities" USING ("Opportunity"."Status Name" = 'Won'))/FILTER("Pipeline Facts"."# of Opportunities" USING ("Opportunity"."Status Name" = 'Closed'))

Result = 0

FILTER("Pipeline Facts"."# of Opportunities" USING ("Opportunity"."Status Name" = 'Won'))/"Pipeline Facts"."# of Closed Opportunities"

Result = 1

I've been working on this for hours trying to find different, creative ways to trick the system to do the math. I created my own "Won Opportunity" and "Closed Opportunity" metric, I've used the out of the box fact ones. I've tried COUNT, SUM, AVG, you name it. I've tried what I think are all the ways to get the Math to work out.

Tagged:

#### Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!