Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Hi there, many thanks for all the feedback and the votes. The feedback clearly tells that there are multiple needs / views out there, and that having this configurable per system is desired. So we will turn this into a system setting for 2.24. Issues:

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

I *think* we discuss the space separator business purely related to display. So when exporting to excel, or any other case where the number is expected to be consumed as a number (including storage in the database), exported via api in json/xml datavalueset etc there should be no spaces, commas

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Hi Lars, Since most people would export to excel and excel in turn would ignore the space hence making it "no separator" option as you mentioned, I would suggest that the comma be used as it quickly gives the number scale at a glance. But whichever way, the majority carries the vote I guess.

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Hi all, many thanks for all the feedback. Will make this configurable per system then given the all the various opinions. Another point of clarification: It seems that space is a preferred separator in the Web based pivot table. However, when downloading to Excel, it seems space is useless as

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Good point: actually it's not only the digit group for pivot table, but rather [digit group, decimal point, default number of decimals] for any [input, output, import and export] that should be defined in the systems settings. But I fear that the implications on the coding will be much bigger

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

In Vietnam it's also comma, so a system wide solution would be good (not for output only, but only for input would be good.. if possible) -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Wed, May 4, 2016 at 12:56 PM, ramaso hasina

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Supporting Jim's suggestion. For Madagascar, the default separator is 'space'. Best regards, - *Hasinarivelo RAMASOMANANA* *mHealth Specialist* Population Services International Antananarivo - Madagascar *​Vies Saines - Résultats mesurables* 2016-05-04 8:44 GMT+03:00 Hannan Khan

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Supporting Jim and Ola on implementation wide settings to configure a default system-wide separator with provision to override for each pivot table. For Bangladesh the default separator is 'Comma'. Regards Hannan HISP Bangladesh On Wed, May 4, 2016 at 1:32 AM, Ola Hodne Titlestad

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Why not use https://docs.oracle.com/javase/tutorial/i18n/format/numberFormat.html where the default format depends on user/setup locale? On Wed, 4 May 2016 at 00:32, Antonia - Pro wrote: > At the start of voting I felt in total minority. > But according to the SI/ISO 31-0

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

At the start of voting I felt in total minority. But according to the SI/ISO 31-0 standard he space is the only neutral separator. The space is appropriate also because in some countries the comma is the decimal separator (not always the

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

of the disclaimer. From: Dhis2-devs [mailto:dhis2-devs-bounces+elmarie=hisp@lists.launchpad.net] On Behalf Of Jim Grace Sent: 03 May 2016 09:13 PM To: Prosper BT Cc: DHIS 2 Users list; DHIS 2 Developers list Subject: Re: [Dhis2-devs] [Dhis2-users] Digit group separator in pivot table - what

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

https://en.wikipedia.org/wiki/Decimal_mark#Digit_grouping seems to support Jim's suggestion of space as default. On 3 May 2016 at 21:32, Ola Hodne Titlestad wrote: > Supporting Jim's suggestion on a system/implementation setting to > configure a default system-wide separator

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

Supporting Jim's suggestion on a system/implementation setting to configure a default system-wide separator in addition to the possibility of overriding this for each pivot table or other type of report with display options. I guess the result of the vote could still be what the default value for