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.

1 Like
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: ##.###,## €

4

In what part ot the question I insert this format?

5

@rdruiz
It’s for SQL queries, not using the Custom question builder.
You should go and upvote by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/3735

6

Hello Flamber,

Thanks for your quick answer.
This is my Query in what part I insert the format currency?

SELECT sum(“dbo”.“MB_OT_Q_Orden_Trabajo_Generada_Q”.“OT_Precio_Cot”) AS “sum”
FROM “dbo”.“MB_OT_Q_Orden_Trabajo_Generada_Q”
WHERE CAST(CAST(“dbo”.“MB_OT_Q_Orden_Trabajo_Generada_Q”.“OT_Fecha_Recib” AS date) AS datetime) = CAST(CAST(dateadd(day, -1, getdate()) AS date) AS datetime)

7

@rdruiz In your case, you would wrap it around your sum(...) function, since that’s the only column you’re selecting. And since it’s SQL, then what functions are available depends on which database and version you’re using, so it’s nothing to do with Metabase here.