Format currency in a Pulse


#1

How can I format a number in a Pulse the same way as it displays on the dashboard? My dashboard displays the number as currency like $X,XXX,XXX.XX but in the Pulse, it just displays a decimal number XXXXXXX.XX.


#2

I solved my own problem. I realized I used the question formatting options on top of my query results. The solution to the problem, in case it helps anyone in the future, is to run the query and format the number as currency, in my case:

to_char(sum(NUMBER), ‘FM$999,999,999,990D00’)


#3

Nice solution! I had to modify it a bit, like this:

FORMAT(THE_NUMBER, 2, ‘de_DE’)

By the way, I added the euro symbol:

CONCAT(FORMAT(THE_NUMBER, 2, ‘de_DE’), ’ €’)

This returned the correct format for me: ##.###,## €