Robert, I saw it too ;-) Thanks
Gerard 2014-01-30 Robert Pollard <[email protected]>: > Gerard > > Glad it worked, however, I did notice one minor error, namely in the opening > line, which should be > if P1F1 >= 1.000 > > Robert Pollard > Information Ecologist > plus.google.com/+RobertPollardNYC > facebook.com/robert.pollard > @climatechange3 > [email protected] > 1.212.864.3156 > > > On Wed, Jan 29, 2014 at 3:19 PM, Gerard van Loenhout > <[email protected]> wrote: >> >> Robert, Don, Bruce, >> >> Roberts solution worked. The others I'm afraid did not. >> >> Thanks for your help! >> >> Gerard >> >> 2014-01-27 Robert Pollard <[email protected]>: >> > Gerard >> > >> > I think you would need to store the value in an A9 format field, as the >> > Format Defaults for Decimal Point Character: >> > and Thousands Separator Character are defined for the entire database - >> > via >> > Shift-F9 >> > >> > Here's a formula that seems to work >> > >> > if P1F1 > 1.000 >> > then >> > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "." ; 1 ] "," >> > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; ".," ; 2 ] "." >> > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 2 ] >> > else >> > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 1 ] "." >> > subfield[ apply.format[ "HZZ.ZZ9,99" ; P1F1 ] ; "," ; 2 ] >> > endif >> > >> > >> > Robert Pollard >> > Information Ecologist >> > plus.google.com/+RobertPollardNYC >> > facebook.com/robert.pollard >> > @climatechange3 >> > [email protected] >> > 1.212.864.3156 >> > >> > >> > On Mon, Jan 27, 2014 at 2:32 PM, Gerard van Loenhout >> > <[email protected]> wrote: >> >> >> >> Good day / evening, >> >> >> >> Does anyone know how to change the comma/point in numbers around? >> >> >> >> I use in fields the European decimals: HZZ.ZZ9,99 >> >> (Comma for decimals) >> >> >> >> But there are reports in which I want to make swith them around. >> >> (Point for decimals) >> >> >> >> What formula would I use? >> >> >> >> Regards, >> >> Gerard >> >> >> >> >> >> _______________________________________________ >> >> Dataperf mailing list >> >> [email protected] >> >> http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf >> >> >> > > > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
