Count Logic

[kamalqlik]

Hi guys,

I have a table structure like this.

I want the output as

If in the Code we have sale in W+8 ie as below For WESR150,AModel we have W+8 =100,

than the percentage should be 100%  ie on the basis of count(W+8) and it should not be zero.

in case fot WESR150 and BModel we have no Quantity ie 0 and for W+7 is 0,but we have the value in w+6 hence it should be 75% and so on.

Help me to build the logic.

Code	Product	W+1	W+2	W+3	W+4	W+5	W+6	W+7	W+8	Sales of 201427	Sales of 201428	Sales of 201429	Sales of 201430	Input Rate
WESR150	A Model	100	0	0	100	0	0	100	100	25	0	15	14	100%
WESR150	B   Model	50	50	30	80	80	50	0	0	15	56	25	105	50%
WESR150	C   Model	50	50	30	80	80	50	0	0	0	0	0	0
WESR150	D   Model	50	50	30	80	80	0	0	0	0	10	0	0	25%
WESR150	E   Model	50	50	30	80	80	50	75	0	0	5	26	42	75%
WESR150	Total													63%

Regards

Kamal

[sujeetsingh]

Confused a lot can you come in simple word with less field variations.