Transform column (Field) with numerical values to live currency

[MudCo]

Hi Team,

I have a a data source from jql wrapped in a table transformer macro. One of the columns (or fields, in my jira source), let's call it ABC. This column has numerical data and I want to convert all the number to say INR and another column for AUD. To maintain confidentially purposes, I am giving a sample data below.

Eg: The column price is numerical in value, without any commas. I tried to convert them so thys look like currency value by using  

SELECT *,

"$" + FORMATNUMBER('Price') AS 'Price'

FROM T*

This gives me all values that looks like '$9,282,736.00' and the other cells we well

But How do I convert them to INR and AUD currencies. 

Note: I am on Confluence Data Centre 8.5.9 and I am using Table transformer macro for custom transformation using sql. My source data is a Jira macro wrapped in this table transformer. 

[John Funk]

Hi MudCo,

I would say that the quick answer would be to add those values in your source data and do the calculation there. You could probably have that done and implemented by the time you receive answers here and try to figure it out. But it's still a value question for getting an answer. 

[MudCo]

Hi @John Funk , this is just a sample data you see in the table, my actual source data is from a Jira project which is wrapped in the macro. Our options are limited and what we are trying to build would eventually be a very long list of issues in the filter. This bit automation will help us immensely. 

[John Funk]

So it's more about the formatting than calculating the values? 

[Stiltsoft support]

Hi @MudCo ,

As you ask a question related strictly to the Table Transformer macro that belongs to the Table Filter, Charts & Spreadsheets for Confluence app, you may refer to our support portal directly. The portal is confidential and all the questions are registered (here we find them manually).

What concerns the case, sorry, seems that we didn't get it. 

You original approach is correct: you can format your numbers and add text/special symbols to them. You can also multiply and divide your numbers - then you may get a new currency if required.