Hi,
Using CR 8.5 / CE 8.5 and Oracle 8i. Using Native connections to Oracle.
Here is the base data
Grp1 989942.59 989943 (On Rounding)
701263.61 701264 (On ROunding)
Grp2 1691206.20 1691206 (On Rounding)
(Grp2 is the sum of values in Gr1)
Grp1 is range of accunts from 1 - 1000 and
Grp2 is range of accounts from 1001 - 2000
Grp1 and Grp2 summation formulas use base dollar amount.
What I want is when Grp1 and Grp2 rounds off to values 989943 and 701264; I want to display the sum of these dollar amounts after roundings, which should be 1691207 and NOT 1691206.
For both Grp1 and Grp2, I am using the same formula, which is DebitAmount + CreditAmount.
Please let me know if you need any more info.
Any help on this is appreciated.
V
Using CR 8.5 / CE 8.5 and Oracle 8i. Using Native connections to Oracle.
Here is the base data
Grp1 989942.59 989943 (On Rounding)
701263.61 701264 (On ROunding)
Grp2 1691206.20 1691206 (On Rounding)
(Grp2 is the sum of values in Gr1)
Grp1 is range of accunts from 1 - 1000 and
Grp2 is range of accounts from 1001 - 2000
Grp1 and Grp2 summation formulas use base dollar amount.
What I want is when Grp1 and Grp2 rounds off to values 989943 and 701264; I want to display the sum of these dollar amounts after roundings, which should be 1691207 and NOT 1691206.
For both Grp1 and Grp2, I am using the same formula, which is DebitAmount + CreditAmount.
Please let me know if you need any more info.
Any help on this is appreciated.
V