Sadly, that's about when I wrote this! It is a Universal Key attached to several other tables so I can't really change it to a double, I guess
Lin On Wed, Nov 8, 2023, at 12:43 PM, 'Karen Tellef' via RBASE-L wrote: > > > Welcome to the not-so-wonderful world of the "REAL" datatype. Long ago in > DOS days that was the only datatype (other than currency) that allowed > decimals. Unfortunately it isn't real accurate IMO (pun intended). Most of > us switched all those Real numbers to the DOUBLE datatype. With Double, a > 104.31 is always stored and displayed exactly as 104.31. With Real, > internally that number may be stored as something like 104.309187983. So > depending on your display formatting, you could get different representations > to the screen. > > Looks like the 000.## type of formatting might be truncating. In my example, > it would display as 104.30 or 104.309 even tho the number is actually 104.31. > Someone else suggested using the ROUND function if you know how many decimal > places you want displayed. > > Karen > > > On Wednesday, November 8, 2023 at 01:47:25 PM CST, [email protected] > <[email protected]> wrote: > > > Hello Razzak, > > Thank you - that is what I was looking for. I knew there was a simple > solution. > > I am getting a strange output though: the real number stored is 104.31 > 000.## prints as 104.30 > 000.### prints as 104.309 > > This is an unusual situation where the number stored could possibly be 4 > numbers to the left of the decimal and 3 to the right (we have never had more > than 2 to the right) > > thanks for the help! > > Lin > On Tuesday, November 7, 2023 at 7:57:30 PM UTC-8 Razzak Memon wrote: >> __ >> Lin, >> >> Here's how ... >> >> Please take a look at the attached illustration. >> • Open the report in Report Designer >> • Right-click on the Variable Object and select Display Format >> • Under the Display Format option change the Display Format to *0.000* >> • Click on the [OK] button to save the Display Format >> • Click on the [Preview] Tab to preview while still in Report Designer >> • Save the report and close the Report Designer >> That's all there is to it! >> >> I hope it helps! >> >> Very Best Regards, >> >> Razzak >> >> >> >>> >>> On 11/07/2023 8:53 PM EST Lin MacDonald <[email protected]> wrote: >>> >>> >>> This will sound silly, but I am working on a system that I wrote several >>> years ago, but can't remember most of what I wrote! >>> >>> I have a report that prints a Var (type: Real) It is now printing it with >>> 7 places after the decimal point. I need it to print a max of 3 places. >>> Where do I set the number of places? I honestly can't rmemeber! >>> >>> Lin >>> >>> >>> -- >>> For group guidelines, visit >>> http://www.rbase.com/support/usersgroup_guidelines.php >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "RBASE-L" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com >>> >>> <https://groups.google.com/d/msgid/rbase-l/1c446867-f6d4-49b8-adc4-3252ed914b4b%40app.fastmail.com?utm_medium=email&utm_source=footer>. > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com > > <https://groups.google.com/d/msgid/rbase-l/c065ed53-23d4-4581-baa4-11a2e5034242n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%40mail.yahoo.com > > <https://groups.google.com/d/msgid/rbase-l/1942164164.930636.1699476193291%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/c022b428-2852-45c0-bb15-d0acaa5c2fee%40app.fastmail.com.
