How do I transfer data to excel from database
The following values are taken from excel-based database, where the actual
#'s are in millions. For reporting purpose, the actual values are divided by
1,000,000 & formatted with 1 decimal (i.e. 1,230,000 = 1.2). My issue is that
the total revenue is also pulled directly from the database & is not a sum.
As you can see due to rounding my revenue does NOT foot down. I need to be
able to tie back to database values. How can this be achieved without a lot
of manual effort (i.e. adding in 0.1's everywhere). Please advice.
Lease Income = 30.0
Interest Income = 3.1
Rmktg Income = 25.7
Fee Income = 2.9
Net Gain = 3.1
Other Income = 1.0
Total Revenue = 65.9
|