Forum Discussion

rylach's avatar
rylach
Icon for Helper II rankHelper II
8 years ago

How to quick select currency from menu to format display data type

Hi,

 

Every time I want to change format of my column or measure and select from Modeling->Data type menu some currency other then one of the top 5 - I have to scroll the long list, which is somewhat inconvenient.

 

Is there any other method then scroll and click for doing this?  Maybe there is an existing feature request for some kind of keyboard search?

 

TIA,

Ryszard.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    rylach,

    You are able to use the following expression or Currency() function to display the number with your currency locale formatting. However, if you need to choose other currency formatting, you have to scroll the menu and click for that specific type.

    FORMAT( column, "Currency")

    Regards,
    Lydia