Can you allow for currency symbol to be specified the data ?

Demetrius Ganesh shared this question 2 months ago
Awaiting Reply

We have a scenario, where we are developing Reports centrally and then deploying them to different clients. These different clients could be in different countries and so we need the same report running at these different installations to show the currency for that particular installation. We currently store the currency in our data and we have to concatenate the symbol to our amounts to achieve this, but we lose out on the totaling and aggregation functionality. It would be nice if the currency symbol setting could allow you to specify it from data.. or even to have it specified for the specific installation of yellowfin.

Comments (1)

photo
1

Hi Demetrius,

When you concatenate the currency symbol to the data, do you do that within Yellowfin and keep the value stored as a numeric? Currently there is no localised currency prefix setting in the Report Builder. I'll investigate to see if this has been suggested before. If not, I'll create a Jira Enhancement request!


Kind regards,

Chris

photo
1

Thanks Chris,

Yes we do the concatenate in a freehand sql calculated field. The enhancement would be really nice,

Demetrius.

photo
1

Hi Demetrius,

Just to query this a little further, would it be possible if you could send an example over of what exactly you're doing and what you're looking for? Currently I understand it as being simply something along the lines of 'If in UK, add £ symbol. If in US add $'.

Is that correct?


Kind regards,

Chris

photo