How to add $ to Jira output via SQL

Megan_dbib63

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_

Hi @Megan,

You may use the following SQL query:

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


Hope it helps your case.