How to remove the money sign "CNY¥"

xuheng925 · May 10, 2022, 1:27pm

The columns (income, cost, etc.) are about money so I pick financial as their types. However we want to remove the "CNY¥" from all reports and keep "¥" or nothing.

flamber · May 10, 2022, 1:30pm

Hi @xuheng925
You can set formatting on what and where to show it. Both in Admin > Settings > Localization, and also on the individual questions in the visualization Settings.

xuheng925 · May 10, 2022, 1:31pm

Hi Flamber, I saw the settings but none of the options is what we want (i.e,. display nothing or simply just "¥" pre the number).

flamber · May 10, 2022, 1:33pm

@xuheng925 Okay, then do not set currency type, but just use regular number and add a prefix or suffix.

xuheng925 · May 10, 2022, 1:37pm

Got it thanks!

mrcwood · January 11, 2024, 11:22pm

@xuheng925 What did you do? I am experiencing this issue as well. I can not "not set currency type."
The option to set column type appears to be removed if it is auto-detected to be currency-- is that right?

I have to select one currency type. Its pre-selected on the localization option from Admin, and I can't unselect it.

josenias · July 18, 2025, 1:08pm

Hello,
You do the following: Before performing the sum with the grouping, you add the custom fields and in the currency field, you convert to integer. Then, in the aggregation, you add this integer field and not the table field.