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.

[MudCo]

I used to get any help regarding table transfer macro here. I am curious to know that we have to now log in our enquiries in another portal. Has something changed? 

[Stiltsoft support]

Seems that there is a kind of misunderstanding - the portal where we are now is called "Atlassian Community" and its about sharing experience among Confluence/Jira/etc. users. Sometimes the Atlassian team also comes here and posts their comments/answers. So, if you want any general help or advice from your fellow users, you may post your question here.

But if you use a 3rd party app and need some help related to the specific macro, it is better to refer to the vendor's support portal. The portal is confidential and all the questions are registered.

Here we just voluntarily and manually try to find any questions related to our app - we don't know if we find all of them or miss smth. For example, in your last reply you called the Table Transformer as "Table Transfer" - if there is such typo in the question name, the manual search won't show this question at all.

[Stiltsoft support]

So, returning to your original question - maybe your issue is how to obtain coefficients for different currencies? So that you'll be able to multiply your money in, for example, dollars on them and get other types of currencies? And you don't want to update these coefficients manually?

Maybe our Table from CSV or Table from JSON macros can help. If there is any live database or website with a suitable data, you can connect it via these macros and get a live table on the same Confluence page.

Then you may use it as T2 inside your Table Transformer macro and perform the required calculations.