Count Logic

kamalqlik — Thu, 07 Aug 2014 06:09:21 GMT

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.

Regards

Kamal

Re: Count Logic

sujeetsingh — Thu, 07 Aug 2014 06:48:33 GMT

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