Forum Discussion

letizia's avatar
letizia
Frequent Visitor
2 years ago
Solved

sorting

Hello, I have a formatted measure (so a text) which I want to sort by numerical value. My issue is that I have both negative and positive value, so even if I try to use 'UNICHAR' method adding "0" an...
Need Help
  • letizia's avatar
    letizia
    Frequent Visitor
    2 years ago

    Hello ,thanks but I don't understand: does dynamic format string allows to treat measure as number and not as text?

    • danextian's avatar
      danextian
      Super User
      2 years ago

      Hi letizia ,

      with dynamic format string you are basically applying a format to a number but not changing its data type so it will still be treated as a number that just appears in either in percentage, currency, etc.

      • letizia's avatar
        letizia
        Frequent Visitor
        2 years ago

        Hello, thank you, it works.