paul29berks
Active Member
- Joined
- Mar 15, 2004
- Messages
- 293
I have 2 sets of data 1 that is split by product:
2004 Actual Data:
Product A 1
Product B 2
Product C 3
Total 2004 6
The other I have only a total:
2005 Plan:
Total 2005 = 8
In order to achieve distribution between Products A-C for 2005 I have % loaded each product i.e
Product A = Product A/Total 2004 * Total 2005
Product B "
Product C "
This is fine - but if I have say 0 as a total for 2004 and 2 as a total 2005. How can distribute evenly?
Can anyone advise?
Thanks
2004 Actual Data:
Product A 1
Product B 2
Product C 3
Total 2004 6
The other I have only a total:
2005 Plan:
Total 2005 = 8
In order to achieve distribution between Products A-C for 2005 I have % loaded each product i.e
Product A = Product A/Total 2004 * Total 2005
Product B "
Product C "
This is fine - but if I have say 0 as a total for 2004 and 2 as a total 2005. How can distribute evenly?
Can anyone advise?
Thanks