![]() |
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 |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com