jvy2002help
MIS
I am new in Crystal Report and would appreciate if someone can help.
I have a formula to calculate the Tax due. EX
Tax Due = 66.00 X 9.75% = 6.44 (it rounds up from the actual value of 6.435)
Total Tax collected = 6.46(this is a fixed value from DB)
The different of Total Tax and Tax Due = .03 (it rounds up from the actual value of 6.46 – 6.435 = .025).
If you do the math 6.46 - 6.44, it should be .02 not .03, and client doesn’t like to see .03
I am thinking just taking the first 2 digits of Tax Due which is 6.43 and ignore the 3rd decimal place. Can truncate function works? please show me the exact step how it works. Or let me know if there is a better way.
Thank you so much.
I have a formula to calculate the Tax due. EX
Tax Due = 66.00 X 9.75% = 6.44 (it rounds up from the actual value of 6.435)
Total Tax collected = 6.46(this is a fixed value from DB)
The different of Total Tax and Tax Due = .03 (it rounds up from the actual value of 6.46 – 6.435 = .025).
If you do the math 6.46 - 6.44, it should be .02 not .03, and client doesn’t like to see .03
I am thinking just taking the first 2 digits of Tax Due which is 6.43 and ignore the 3rd decimal place. Can truncate function works? please show me the exact step how it works. Or let me know if there is a better way.
Thank you so much.