Not Planned

Allow Report 2.0 to Group by Formulas


Userlevel 7
It would be great if when I built reports in Report 2.0 I was able to group by a formula field.  I can do this in standard Salesforce reports, but not Gainsight Reports.  

15 replies

Userlevel 5
Elleno,

Salesforce doesn't allow us to group by a formula field.  Its a platform limitation.

Thanks,
Sumesh
Userlevel 7
Sorry, not a formula created in the report, a custom field that is the type of Formula.  We create summary reports in Salesforce all the time that use text formula fields for groupings/summaries. 
Userlevel 5
Ellano,

As mentioned in my previous post, salesforce doesn't allow us to "group by" a formula field. You can refer the salesforce community thread on the same here https://success.salesforce.com/ideaview?id=08730000000HlNtAAK

Thanks,
Sumesh
Userlevel 7
I am sorry.  We create reports all the time in Salesforce that are summary reports where the summary is a custom formula field created on the object.  Are we talking about different things?  
Userlevel 5
Hi Elleno,

You can create summary reports using formula fields in salesforce. However, salesforce doesn't expose that ability for an app built on salesforce. Gainsight is an app that is built on salesforce and hence cant summarise by a formula field.

Please let me know if this clarifies.

Thanks,
Sumesh    
Userlevel 7
Thank you!  That does clarify.  We will continue to build all our reporting in Salesforce and not Gainsight.  
Userlevel 6
Just wanted to see if this is something we've been able to explore more in the last 9 months or find a workaround.  I'm assuming not, but had a customer ask today.  Thanks!
Userlevel 4
We were able to find a workaround by loading the dataset to MDA and then running reports off of that particular field.
Userlevel 5
Badge
We also need this functionality. We have a custom Forecast Category field calculated in SFDC using formula. We cannot use it as Break by field in GS reporting.

Any update when this feature will be released?
Userlevel 6
Elinat, would it be possible to load the dataset in MDA and then run the report there? There are 2 options here a) Copy from SFDC to MDA (where formula fields get converted as text) or use MDA platform from scratch (without loading in SFDC) and create a formula field there. 
Userlevel 5
Badge
I'm running a report on opportunities . Do you suggest that I will upload (copy) Opp data into MDA and then run the report on MDA data?

To get it work as if the data is live , I will need to have this rule run many times per day.

Do I miss anything?
Userlevel 5
Badge
Gaurav - please clarify your suggestion.
Userlevel 7
Badge
Any chance SFDC is going to expose this ability in the future?
Userlevel 7
Badge +1
Hey Guys, I wanted to follow up on this one for a customer and see if there are any updates especially since this grouping by formula fields is possible in Salesforce, and the level of effort required to do this workaround is very high. I assume many other customers are using formula fields to allow for this type of reporting so it would be a huge win across the board. 
Userlevel 7
Badge +1
We currently need this as well. An MDA work-around is incredibly time consuming and delays seeing live data so adding one of these reports to a dashboard could result in inconsistencies if some reports are live and some (because of this limitation) are waiting for a rule to update. Our field in question does not have the option to be a lookup, is not numerical and does have a select number of options.

Reply