praveenjain64
New Member
- Joined
- Feb 7, 2014
- Messages
- 7
Hi,
I tried a lot of ways to fix this by TRUNC & ROUND to restrict this happening, but I am not successful.
I am using a nested formula which has a small subtraction within it.
There are few cases when the subtraction is does not works if thought I have the subtraction within TRUNC.
E.g.: 5.36 - 4.6
The simple subtraction always shows as 0.76 where as when I have nested this calculation with a TRUNC in the formula is shows the result as 0.760000000000001
I tested the formula in edit mode by pressing F9 key & the result is 0.760000000000001.
Could someone help me with this please?
-Praveen
I tried a lot of ways to fix this by TRUNC & ROUND to restrict this happening, but I am not successful.
I am using a nested formula which has a small subtraction within it.
There are few cases when the subtraction is does not works if thought I have the subtraction within TRUNC.
E.g.: 5.36 - 4.6
The simple subtraction always shows as 0.76 where as when I have nested this calculation with a TRUNC in the formula is shows the result as 0.760000000000001
I tested the formula in edit mode by pressing F9 key & the result is 0.760000000000001.
Could someone help me with this please?
-Praveen