Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report question

Status
Not open for further replies.
Jul 23, 2010
5
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top