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

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

Formulas aren't working

Received Response
28
Views
2
Comments
edited Jan 14, 2019 6:41PM in Reporting & Analytics for Sales 2 comments

Summary

Trying to do math to create a custom metric and formulas aren't working.

Content

Hello,

I'm trying to calculate the percentage of future dated activities on an opportunity. First, I need to calculate that using this: CASE WHEN "Activity"."Due Date"> Current_Date then COUNT(DISTINCT "Sales - CRM Pipeline"."Pipeline Facts"."# of Opportunities") else 0 end. This formula works and returns results.

Then, I'm doing this: 100*SUM(CASE WHEN "Activity"."Due Date"> Current_Date then COUNT(DISTINCT "Sales - CRM Pipeline"."Pipeline Facts"."# of Opportunities") else 0 end)/SUM("Sales - CRM Pipeline"."Pipeline Facts"."# of Open Opportunities"). This is not erroring out but it's also returning '0' as the results. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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