Skip to main content
Question

unable to group by certain fields in reporting

  • April 18, 2018
  • 1 reply
  • 134 views

ky_powell
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
I am unable to group by a user/name field, and I think this may be because the data type of this field is a formula. Are formula fields not able to be grouped by even if they contain non-numeric values?

1 reply

danny_hallgren
Forum|alt.badge.img+4
  • Gainsight Employee ⭐️
  • April 19, 2018
Hi Ky!

I think the problem you are seeing is that you cannot group by formula or number field types. 

It appears that the field in question refers to a user (CSM), however if it's not a lookup field type, but instead a formula driven field type, you cannot group by that specific field.

I hope that answered your question.