Hi all......

Here is my requirement. I am clear with my logic. But i am blocked at Code. How can i get this...

Here is the example...

I need to produce a Score card.

Where i need to calculate score of a dealer as per Question category and the Customers reply.

I am trying to clear my Need here.

Suppose The data is as Follows

1) dealer "A"

2) Question Category "1"

3) Number Of question in Category "1" = 2

4) Marks for Question = 1 (N) else 4(Y)

If Dealer "A" has 4 customers and 2 of them replied then.

Here are the Inputs for Scorecard.

1) Total Question for Dealer "A" of Category "1" => 2(Customers) * 2 (Questions) = 4

2) Marks = 4 * 4 = 16 (Considering Y case)

3) Total Marks = 16

Here the score of Dealer "A" is "**100%**" MI right? If yes then please tell me how to get this by calculation. Please Help me.

Thanks in advance.

Have a Nice Time. :)