Sign Up ›
  • Adminforsfdc
  • NEWBIE
  • 0 Points
  • Member since 2012
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
2 replies

Adding a percentage for reporting of record counts

I am trying to take the record count of a column and divide it into the grand summary total record count  for a percentage in a report. I tried using this formula  RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY) to create a summary by record count percentage by total summary record count based on discussion boards I have read upon on. I get an error message:  Error: Invalid custom summary formula definition: Incorrect number of parameters for function 'PARENTGROUPVAL()'. Expected 3, received 2.

 

Can someone help me?

 

Thank you

8 replies

Spring 09 - PARENTGROUPVAL overcomes "percentage of total" limitation on reports...?

Hi All,
 
Our group is relatively new to Salesforce, which we're using for our Tier 1 Call Centers.  We've quickly come across some limitations in 'counting' records when running reports.  I've seen other posts mentioning that it wasn't (easily) possible to get the percentages of total counts in a report, but after seeing the new PARENTGROUPVAL introduced in Spring 09, I gave it a go:
 
In a report, create a new Custom Summary Formula:
 
RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)
 
FYI - At the "Where will this formula be displayed?" section, PARENTGROUPVAL is only available at the "Grouping 1" level (not at the 'all summary' or 'grand summary' levels), which makes sense.
 
I haven't seen much of anything else mentioned about PARENTGROUPVAL just yet, but I'm curious if anyone else has found easier ways to calculate similar percentages, with our without this function.
 
Cheers!

Mark
Message Edited by Mr Sling on 02-25-2009 03:04 PM