hi - i’m doing something wrong, but don’t know what.
built a simple flow using an import from excel but when i try to sort the rows it’s not really working.
parabola seems to be treating the numbers as numbers…but the sort is all off. and if i ask it to only show negative numbers, it shows nothing. any ideas?
`
Hi Tim,
It looks like you’ll need to reformat your “13- YTD Sales” column before sorting. Using a format with symbols like $, %, or a comma (,) will cause the columns to sort incorrectly.
To have that column sort the way you’d like, you’ll need to choose 2500.00 in your first Format numbers step:
You should then see everything sort correctly in your Sort rows step. You can then add a Format numbers step after your Sort rows step to adjust the numbers to $2,500.00.
Let me know if you have any questions!
