Solved: Compare strings with greader than or less than - Page 2

gabynufe · 06-16-2022 09:40 AM

Hi,

I am trying to enter an expression to compare two strings, greater than or less than, but it sends me the following error:
Arithmetic expression '([Location] > "A")' does not have valid input types

I think this comparison only accepts numbers or dates.

Is there any way to do it with strings?

dbaum

I don’t know the answer, and will be interested to hear others’ advice and maybe try some techniques myself later.

Meanwhile, an alternative idea would be to compare the sequence of your sorted and unsorted list of 2 items. Maybe something like:

CONCATENATE(LIST(“A”, [Location])) = CONCATENATE(SORT(LIST(“A”, [Location])))

View solution in original post