SAP Knowledge Base Article - Public

1981517 - Japanese currency symbol from YEN function display as dollar symbol when preview it in Dashboard

Symptom

  • Japanese currency symbol from YEN function display as dollar symbol when preview it in Dashboard
  • Japanese currency symbol ￥ display as $

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • Dashboard 4.0
  • Dashboard 4.1

Reproducing the Issue

  1. Create new dashboard report.
  2. Set cell B4 as 999999, C4 as YEN(B4).
    Only in Japanese version system, YEN function is able to use in Excel.
  3. Insert Label to canvas and set it display the C4.
    1.png
  4. Preview the dashboard.
    Note that the Japanese currency is displayed as dollar symbol.
    2.png

Cause

  • YEN function is not supported in Dashboard.
  • Search "Supported Excel function" in Dashboard's Help guide.

Resolution

Work around:

Do not use YEN() function, directly format the cell as Japanese currency symbol.
3.png

Keywords

dashboard, JPY, ￥、円,通貨,円通貨,マック, ドル, プレビュー, 関数, formula , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1