Suggest an Idea

[t_donnet]

Hi,

Banks have the auto format for all values , but want the exact value when it's under a million (with thousand separator).
The KPI chart doesn't display correctly the value. 

Keep in mind that there is more than a hundred measures in each apps.

In the main script, the variables are on the ThousandSep & the NumericalAbbreviation.

SET ThousandSep="'";
SET DecimalSep='.';
SET MoneyThousandSep="'";
SET MoneyDecimalSep='.';
SET MoneyFormat='# ##0.00 CHF;-# ##0.00 CHF';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-CH';
SET CreateSearchIndexOnReload=1;
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
SET NumericalAbbreviation='6:mio;9:mia;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
//SET NumericalAbbreviation='3:k;6:M;9:bn;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

When the number format is set to Number. The value is display with the thousand separator

No problem here

When the number format is set to Auto. The value is displays with the abbreviation (more than 1 million)

This is correct

When the number format is set to Auto. The value is displays with the abbreviation (less than 1 million, no abbreviation)

No thousand separator

Thanks for your help.

Regards,
Théo

[francesco_menin]

totally need this feature when changing default numerical abbreviations

[Patric_Nordstrom]

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 
Patric

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.