Lookup BIGNUM - you can specify the bignum number to have only two
digits, the way I read it.
Albert
On 11/6/2014 10:21 AM, jan johansen wrote:
Maybe. But the displayed value can have no more than 2 significant
figures.
-----Original Message-----
From: Albert Berry <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 06 Nov 2014 10:19:39 -0700
Subject: [RBASE-L] - Re: report display problem
Would BIGNUM work (assumes you are in 9.5 (64) ). For the report
create a BIGNUM variable just for the display.
Albert
On 11/6/2014 9:51 AM, jan johansen wrote:
Hey all,
I have a formatting problem that I don’t believe that I can use
formatting for.
The requirement is that the displayed number (in a report) can
have no more than 2 significant figures displayed.
Non-zero digits are always significant. Thus, 22 has two
significant digits, and 22.3 has three significant digits.
With zeroes, the situation is more complicated:
1. Zeroes placed before other digits are not significant; 0.046
has two significant digits.
2. Zeroes placed between other digits are always significant;
4009 kg has four significant digits.
3. Zeroes placed after other digits but behind a decimal point
are significant; 7.90 has three significant digits.
4. Zeroes at the end of a number are significant only if they
are behind a decimal point as in (c). Otherwise, it is
impossible to tell if they are significant. For example, in
the number 8200, it is not clear if the zeroes are
significant or not. The number of significant digits in 8200
is at least two, but could be three or four. To avoid
uncertainty, use scientific notation to place significant
zeroes behind a decimal point:
8.200 ´ 10^3 has four significant digits
8.20 ´ 10^3 has three significant digits
8.2 ´ 10^3 has two significant digits
So I believe that the best thing for me to do is to use
scientific notation.
The column definition I have been using in the report is a
Double. I cannot change the type but I know that this is a
display issue.
However, my attempts to “force” scientific notation have not worked.
Any advice appreciated.
Jan
