How to add $ to Jira output via SQL

[Megan]

I am using the Jira for confluence macro to display a list of tickets and their associated value in a column we are calling Revenue. I want to use the table transformer to add a dollar sign ($) in front of the values - as Jira does not have this field formatted as currency.

Right now I see:

Key | Revenue

Ticket 1 | 124.5

Ticket 2 | 1000.0

I have tried utilizing Concat or Format for SQL and can't figure out how to append the '$' in front of all 

SELECT CONCAT('$', FORMAT('Revenue'));

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @Megan,

You may use the following SQL query:

SELECT 'Key',
FORMATWIKI("$" + 'Revenue') AS 'Revenue, $'
FROM T*


Hope it helps your case.

[Megan]

 Please ignore