aggregate groupping using number field

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi,

Just to make sure i'm not overlooking anything.

I do not seem able to create an aggregate Grouping based on a SF number field.

Is my only solution to create a new picklist field on that object (or text field) and have a workflow update that field with value?

Hope not

Please let me know

Thx 
Photo of Dave

Dave

  • 5,538 Points 5k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
What about a Salesforce formula field that just equals the number field? Would a UI only formula field work?
Photo of Dave

Dave

  • 5,538 Points 5k badge 2x thumb
Unfortunately, grouping cannot be done on a SF formula field, and I had tried creating UI-only formula, but this Ui field does not appear in list of fields available for grouping
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
That's what the tech guys call a "double bummer"...
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,704 Points 20k badge 2x thumb
Yup. Been here as well. Workaround is to create a Text field that gets it's value from the number field using: Workflow, Process Builder or Apex Trigger.
Photo of Dave

Dave

  • 5,538 Points 5k badge 2x thumb
That's what I thought, thx for confirming i'm not loosing my mind :D