Formatting a Value Field

user08392
user08392
in Archive

Hi All,

 

I have value column with numbers like 431000.97 . It should be formatted like $431k.  How can we achieve it. I have tried with round , concate etc but exactly what I needed I couldn't get it. Is there a way? Using concate it is changing to category and couldn't sum values. Please help

Comments

  • Godzilla
    Godzilla Contributor

    Are you trying to do this on a chart or a table? You can format labels or hover overs to show value fields in various formats. Can you provide little more detail as to where you're trying to do this formatting?

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Unknown
    Unknown
    Hi Godzilla, I have been trying in creating card(table view).. I have seen options like format type number or currency. I can use currency and decimal to 0 but how can I get "K" . Thanks
This discussion has been closed.

Categories