Home     Contact     Sitemap
        
  Support

Ambiguity between decimal separator and list separator

Document ID: DQ026
Relevant to following products: WorkOut 2.0 Manta
Document description: How to: Specify fractional numbers in a list when working in a locale with a , decimal separator…



When working in a locale with a radix (decimal separator) which is a comma i.e. “,” (as in Germany) there may be ambiguity when specifying a list of numbers.  For example:
 
Mean (1,2,3,4)
 
Is this the mean of the numbers “1,2” and “3,4” or the mean of the numbers 1 2 3 and 4?
 
To resolve this ambiguity, when specifying a list of numbers where your regional decimal separator is , include the decimal separator with each number.  Also, it is easier to read if you space your numbers,
 
For example, the mean of the numbers 1 2 3 and 4:
 
mean (1,0, 2,0, 3,0, 4,0)
 



Related articles:
DQ027: Problem importing sample import files
How to: Import sample import files in non US/UK locales…





 Search again

  Evaluate
  Download software now:

    WorkOut 2.5
    Manta
    Stingray
  Support
    Search Knowledge Base
    Browse Knowledge Base
    Submit a query