A
april
I am using a not-for-profit accounting system called Blackbaud. I am
downloading financial statements from this system using Crystal report
format. The reports come into Excel with 2 decimal places. I know that I
can format the Excel spreadsheet with 0 decimal places but when I foot and
crossfoot a column or row I can have problems with the rounding.
For instance I show this on the download
Col 1 Col2 Col 3 Total
64043 10617 1049 75710
If you add col 1,2, and 3 as they appear, it totals 75709.
This is because the real numbers in these columns are
Col1 col2 col3 total
64043.38 10616.88 1049.25 75709.51
I want the total to be 75710. I can’t use @ int because I lose values. Can
anyone help me with this issue?
Thank you in advance for your help.
downloading financial statements from this system using Crystal report
format. The reports come into Excel with 2 decimal places. I know that I
can format the Excel spreadsheet with 0 decimal places but when I foot and
crossfoot a column or row I can have problems with the rounding.
For instance I show this on the download
Col 1 Col2 Col 3 Total
64043 10617 1049 75710
If you add col 1,2, and 3 as they appear, it totals 75709.
This is because the real numbers in these columns are
Col1 col2 col3 total
64043.38 10616.88 1049.25 75709.51
I want the total to be 75710. I can’t use @ int because I lose values. Can
anyone help me with this issue?
Thank you in advance for your help.