Eddie Mason
Registered User.
- Local time
- Today, 23:27
- Joined
- Jan 31, 2003
- Messages
- 142
I have a problem when storing a calculated field with two decimal points. If I set the field to double, fixed, 2 decimal points. For the field it will show the calculations as:
21.364 as 21.36
21.563 as 21.56
21.272 as 21.27
Which is how I want it to be, however when I run a summary of the field rather than showing 64.19 it calculates as 64.20, I know that this is the correct figure but is there any way I can get it to show me the 64.19? Hope someone can help.
21.364 as 21.36
21.563 as 21.56
21.272 as 21.27
Which is how I want it to be, however when I run a summary of the field rather than showing 64.19 it calculates as 64.20, I know that this is the correct figure but is there any way I can get it to show me the 64.19? Hope someone can help.
