#### 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.