OI4WG 3.5 Urgent fix required please... (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== OI4WG 3.5 Urgent fix required please... (OpenInsight Specific) ====
=== At 17 FEB 1998 07:21:02AM Andrew Gebbett wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
The following applies to OI4WG version 3.5.



To display numbers to two decimal places we use the "MD20," conversion throughout our applications. Whilst this conversion is OK in 99% of cases, unfortunately it gives incorrect results where a number is returned from a calculation in standard form. An easily reproducable example is given below:



A=7.4326843E-2"

B=OCONV(ICONV(A,"MD2"),"MD2,")

C=OCONV(A,"MD20,")



B gives the correct answer of 0.07 but C returns 7.43.



Could you please issue a patch since I assume this should be an easy fix. For us to change all our code would be a huge task!



Regards,



Andrew Gebbett

CSSP UK
</QUOTE>
----

=== At 17 FEB 1998 09:29AM Skip Tinnell wrote:  ===

<QUOTE>Andrew,



Interestingly, when the quotes are removed from A, C returns the correct answer, i.e.:  A=7.4326843E-2 instead of A=7.4326843E-2".

</QUOTE>

----

=== At 17 FEB 1998 09:42AM Steve C. wrote:  ===

<QUOTE>I'm running into the same problem. I calculate percentages.

OI gives the same answers to both of these.

3155/111060= 2.84 (instead of .0284)

315500/111060= 2.84 (correct)

</QUOTE>

----

=== At 17 FEB 1998 10:30AM Steve C. wrote:  ===

<QUOTE>This is the code as a dictionary symbolic that

computes the wrong percentage as noted above.

TEMP_GROSS={GROSS_SALES}

IF TEMP_GROSS=" THEN TEMP_GROSS=0

IF TEMP_GROSS0 THEN

 @ANS={AB_SALES}/{GROSS_SALES}

END ELSE

 @ANS=0

END

.

Steve C.

</QUOTE>

----

=== At 17 FEB 1998 07:07PM Andrew P McAuley wrote:  ===

<QUOTE>Interesting - I suspect a side effect of the changes to allow 0.0 to be seen as different to .0. Seems like "don't quote me on that" [i](it's all eggs bacon beans and a fried slice)[/i] is the order of the day.



amcauley@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura Ltd[/url]

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]



PS Free Insulated Sprezz coffee mug to the first person to guess correctly what the **** the quote above is from....

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=C9BCB7C3D29C13EB852565AE0043D7F9|View this thread on the  forum...]]