What I haven't tried is adding a formula as a fiel...
# suiteanalyticsg
George McMullen
04/23/2019, 12:06 AMWhat I haven't tried is adding a formula as a field and sorting by that.
n
Noel B
04/23/2019, 2:46 PMWhat do you mean adding it as a field? It is already a field in my saved search and I actually have 13 fields that are a formula. I would like to try and sort by 3 of those fields first, but they are not one right after each other.
g
George McMullen
04/23/2019, 5:02 PMmessage has been deleted
George McMullen
04/23/2019, 5:02 PMmessage has been deleted
George McMullen
04/23/2019, 5:03 PMBasically, adding a formula as a field to the record itself.
George McMullen
04/23/2019, 5:04 PMSelect the type as the output (e.g. Decimal Number), and deselect "Store Value". Then under Validating and Defaulting, click the checkbox next to Formula, and then put your formula into the "Default Value" field.
George McMullen
04/23/2019, 5:05 PMThen you can go back to your saved search and sort by that field (which in the background is a formula). It won't matter what the position is anymore.
n
Noel B
04/23/2019, 8:06 PMThanks! I'll try this out.
👍 1