FireGeek21
Technical User
Hi,
I need a formula that will force a number field not to round. It seems because of settings in File -> Options -> Fields tab -> Number -> Number tab my formula field is rounding to 2 decimal places. I need the full 4 decimal number to show. Cavaet is that this ends up displaying in a TEXT field. So, I can't just change the format of this field to show 4 decimals. I also can't change the Option settings - using Crystal on a Citrix server.
So, looking for a formula that can override the Option settings and will give me an unrounded 4 digit decimal. Tried ToText([field], "0.0000") and tried Truncate([field], 4) - neither work.
Thanks!
FireGeek
(currently using Crystal Reports XI with Lawson 9.01)
I need a formula that will force a number field not to round. It seems because of settings in File -> Options -> Fields tab -> Number -> Number tab my formula field is rounding to 2 decimal places. I need the full 4 decimal number to show. Cavaet is that this ends up displaying in a TEXT field. So, I can't just change the format of this field to show 4 decimals. I also can't change the Option settings - using Crystal on a Citrix server.
So, looking for a formula that can override the Option settings and will give me an unrounded 4 digit decimal. Tried ToText([field], "0.0000") and tried Truncate([field], 4) - neither work.
Thanks!
FireGeek
(currently using Crystal Reports XI with Lawson 9.01)