• BigA
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Ok folks, here's one I need some help with...For anyone who has used PARENTGROUPVAL...

 

I created a report to help me figure out the rate of conversion for opportunities from propsect opportunities to qualified opportunities. Essentially, when an opportunity is set to the 'Qualified Opportunity' stage (from prospect opportunity stage), a calculated field enters text, "Yes" - otherwise, it's "No". My report groups all opportunities first by Owner and then by Qualified Opportunity (either yes or no). This part all works fabulous. What I want to do is figure out the rate of conversion for each of my reps using a Custom Summary Formula. I want to use PARENTGROUPVAL to help me. Here is how I built it:

 

RowCount/PARENTGROUPVAL(RowCount, Owner)

 

The formula calculation would be displayed at the Grouping 2: Qualified Opportunity level.

 

The idea is that it would divide the total opps (RowCount) in each Qualified Opportunity grouping (Yes or No), by the total number of opportunities for each owner (PARENTGROUPVAL(RowCount, Owner).

 

Based on how I read the help and other postings on the community, this should work. However, I get this error: "Field Owner does not exist. Check Spelling."

 

I have tried everything I can think of to get this to work, and no luck. Maybe I have misunderstood how it works (not hard since there isn't much help on this forumla function).  I have tried several diffrerent field names and even different grouping levels, but can't seem to get the field name correct. Maybe I am just using it completely wrong.

 

Any help would be great. I'm sure I am just missing something obvious, but sometimes you just need a second pair of eyes to help see it. I would appreciate any feedback at all. Thanks!

  • June 28, 2010
  • Like
  • 0