Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I cannot find ANY help with what proper references to use for this. If my report has only one column to the matrix (first screenshot), the following Formula works to product percentages per row in the one column. If I have MORE than one column, it produces the data based on ALL columns (100% for the entire table, not per column). Can someone guide me on how to adjust the formula to work "per column" so each column totals 100%?



Screen 1 = one column, no problem: No problem

Screen 2 = problem: Problem

share|improve this question
Did you ever figure this out? I've run into the same exact situation. – user25815 Oct 26 '15 at 19:33
up vote 2 down vote accepted

Had to reference the correct column variable in the function to make it work:

Originally THIS


now becomes THIS


This gives 100% totals per column instead of only at the Summary.

share|improve this answer
Unbelievably, over a year later, this is a problem yet again. I cannot fathom how to get the FIELD NAME that it expects, apparently. The Column field is "PB UTP Summary (Client)". I've tried every iteration of the underscored version of it I can think of - it won't parse. >:-( PB_UTP_Summary_Client, and various others. With and without __c. With parentheses. (sigh) – AMM May 8 '14 at 20:27
you need to summarize the field. My_Field__c:AVG or My_Field__c:SUM, etc. – Scott Pelak Apr 28 at 16:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.