unable to group by certain fields in reporting

  • 2
  • Question
  • Updated 3 months ago
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?

Photo of Ky Powell

Ky Powell, Champion

  • 2,332 Points 2k badge 2x thumb

Posted 3 months ago

  • 2
Photo of Danny Hallgren

Danny Hallgren, Employee

  • 240 Points 100 badge 2x thumb
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.
(Edited)