Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Confused a lot can you come in simple word with less field variations.