Cotufero2002
New member
- Joined
- Nov 26, 2012
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi guys,
I have the following problem, trying to obtain the new quantities for the historical data skeleton, achieving the 6 respective conditions.
Let me explained a little bit better, I can prorate the current historical data, and then apply its % to condition 1, then some rounding and I will achieve condition 1 (example: sum of p23 = 586) , but it wouldnt achieve conditions 2-6 (example: sum of venue d/C11 = 435). This because conditions 2-6 are not based on the historical data %. Historical data is mainly to generate a brief idea of budget behavior.
Also, I could start prorating by conditions 2-6 , and then some rounding, and I will achieve it, but I cannot comply with condition 1. (Example: sum of venue a/C1 = 9086 ) but (sum of p24= 321).
The deal here, is to comply with the 6 conditions at the same time. (Product Qty, Venue, Client).
Sum of Condition 1= 166035
Sum of Condition 2-6 = 166035
Got any ideas?
Thanks.
I have the following problem, trying to obtain the new quantities for the historical data skeleton, achieving the 6 respective conditions.
Let me explained a little bit better, I can prorate the current historical data, and then apply its % to condition 1, then some rounding and I will achieve condition 1 (example: sum of p23 = 586) , but it wouldnt achieve conditions 2-6 (example: sum of venue d/C11 = 435). This because conditions 2-6 are not based on the historical data %. Historical data is mainly to generate a brief idea of budget behavior.
Also, I could start prorating by conditions 2-6 , and then some rounding, and I will achieve it, but I cannot comply with condition 1. (Example: sum of venue a/C1 = 9086 ) but (sum of p24= 321).
The deal here, is to comply with the 6 conditions at the same time. (Product Qty, Venue, Client).
Sum of Condition 1= 166035
Sum of Condition 2-6 = 166035
Got any ideas?
Thanks.