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 <http://twitter.com/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
