• FD Frank
  • NEWBIE
  • 0 Points
  • Member since 2012

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

Hi All,

 

I'm trying to create a Sales Rep Scorecard to report to calculate the % of a reps activities that are meetings vs. calls (of total activities).  I've created a matriix report with summary rows showing Toal activities and sub-rows showing total number of calls and total number of meetings but can't figure out how to divide #meetings by #total activities per saes rep.  I've been trying to use PARENTGROUPVAL and PREVGROUPVAL divided by "RowCount" but no luck in referencing the right values.

 

Thanks in advance.

 

Frank