|
Hello,
I have the data displayed below in a cross-tab and have imported a MS Excel spreadsheet with a different type of data for Jan – Dec. I then need to take the data from the cross-tab and multiply it by 1,000 then divide it by the data from the spreadsheet for each month for each company and each product type.
For example: to calculate the number for company ABC for January for product type A1 the formula would be (2*1,000)/19,259 = .1038. And February: (2*1,000)/17,581 = .1137, etc… I apologize if this sounds a bit confusion but I don’t know of an easier way to explain this. This calculation can easily be done in MS Excel but I want to see if there is a way to do this same calculation in Crystal Reports.
Any help anyone could provide would be greatly appreciated!
Cross-tab
|
Product Type |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
A1 |
2 |
2 |
7 |
2 |
9 |
2 |
8 |
10 |
6 |
13 |
8 |
4 |
|
B1 |
4 |
8 |
11 |
14 |
10 |
10 |
3 |
7 |
7 |
3 |
13 |
3 |
Spreadsheet imported
|
Company |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
|
ABC |
19,259 |
17,581 |
19,554 |
17,967 |
19,119 |
18,046 |
18,567 |
19,801 |
19,410 |
19,179 |
18,158 |
19,154 |
|
XYZ |
9,111 |
8,299 |
9,284 |
8,785 |
9,674 |
9,391 |
9,004 |
8,937 |
9,128 |
9,183 |
9,157 |
8,987 |
Result
|
Result |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Company ABC |
0.1038 |
0.1137 |
0.3579 |
0.1113 |
0.4707 |
0.1108 |
0.4308 |
0.505 |
0.3091 |
0.6778 |
0.4405 |
0.2088 |
|