Hi All,
I was wondering if anyone is able to help me.
As mentioned in the title - I'm trying to format numbers (money, different currencies depending on the region) dynamically. Applied Money() function:
Money(Avg(price), $(vMoney))
works perfectly fine (we can easily see the currency symbol next to price for every product), but we received a complain from the end user that numbers are being formatted as text when using Send to Excel option.
Author of the below article:
Dynamic number formatting in chart expressions. Pros and cons • inqlik.gitgub.io
stated that using money() function will allow us to keep the numbers format as numbers during the Excel export.
I was wondering if any of you have any advice. I don't think this is the top priority for this application and we can probably take the currency symbol outside of the expression (adding info about it somewhere in the expression caption or pivot table title), but was wondering if there is anything we can do about it to keep the numbers clean & tidy?
Thanks in advance!
