I have a formula that I have created that works but does not display the end result as expected. The code looks like this
if (isnull({agt_rx.rx_dose_range}) or {agt_rx.rx_dose_range} <= 0) then totext({agt_rx.rx_dose} / tonumber({agt_rx.dose_strength}),0) else
totext({agt_rx.rx_dose}/tonumber({agt_rx.dose_strength}),0)&" to "& totext(({agt_rx.rx_dose_range}/tonumber({agt_rx.dose_strength})),0)
Doing it this way, the numbers display as whole numbers only so if it sees a 0.5 it displays it as 1. What I would like to have the number display as is as follows.
I can get the number to display like this without a problem
1.0500
1.4050
1.2345
But what I need is for the numbers to display like this
1.05
1.405
1.2345
The formula above is used in calculating medications so it's one of 6 formulas added to a text box on the report so I can not conditional format the "number display". is there a way to tweak this code to make it display correctly?
Edited by bernieL - 25 Sep 2010 at 8:42am
IP Logged