Troubleshooting
Problem
The currency symbol that is defined through a TEXT formula is correctly rendered in Excel:
TEXT(1234,"$#,##0.00") ==> $1,234.00
TEXT(1234,"€#,##0.00") ==> €1,234.00
TEXT(1234,"£#,##0.00") ==> £1,234.00
TEXT(1234,"€#,##0.00") ==> €1,234.00
TEXT(1234,"£#,##0.00") ==> £1,234.00
But only the dollar $ sign is appearing in TM1 Web, whatever the regional settings and browser content language that are used for either creating the Excel file or opening TM1 web:
TEXT(1234,"$#,##0.00") ==> $1,234.00
TEXT(1234,"€#,##0.00") ==> 1,234.00
TEXT(1234,"£#,##0.00") ==> 1,234.00
Resolving The Problem
In Excel, in the TEXT formula, for currencies other than dollar $, use these custom formats instead:
TEXT(1234,"[$€]#,##0.00")
TEXT(1234,"[$£]#,##0.00")
TM1 Web will then show the correct symbol.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzJnAAK","label":"Modelling->Workbook\/Websheet Design"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
04 June 2020
UID
ibm16220218