I have a stored procedure in QuickBooks that I run, so I can't modify it, but the data it returns resembles a crosstab and looks like this:
Amount_1, Amount_2, Amount_3 are really months (Jan, Feb, March) and the values are the total dollars spent for each account number in that month.
Now, what I need to do is devide each dollar amount (for each Account Number) with the total pounds that we produced that month. So, I have a table with all the pounds for each month, but I don't know how to "link" it to the specific "Amount_X" (month)
Code:
SequenceNum VarAccntName AccountNumbr Label Amount_1 Amount_2 Amount_3
1 Metal 5000 5000 · Alloy Costs 78337.84 76377.99 54113.81 113571.11
1 Metal 5002 5002 · Metal Costs 110479.84 115848.59 70376.01 124767.77
6 General 5004 5004 · Melt Material 11560.2 2277.45 2545 7938.91 2423
6 General 5006 5006 · Core Material 15603.3 17289.05 12891.7 17365.99
6 General 5008 5008 · Cores - Purch 1330 1873.62 2858.4 4260.06 2762.17Now, what I need to do is devide each dollar amount (for each Account Number) with the total pounds that we produced that month. So, I have a table with all the pounds for each month, but I don't know how to "link" it to the specific "Amount_X" (month)