Urgent: creating a scorecard

[sayadutt]

Hi Team,

I have a requirement where I need to publish a scorecard based on the values present in the fields. The values will be either  Yes, No, Not Applicable or empty. OR received, Not Received, Not Applicable and empty.

Data file is attached.

Now the scorecard should calculate the percentage of Yes and assign marks:

Marks:

4: If Yes is more than 90%

3: If Yes is more than 60% and less than 90%

2: If Yes is more than 30% and less than 60%

1: If Yes is less than 30%

scorecard should look like this:

Division	Application	Test Case Sign Off	Test Case Present	Requirement Sign Off	Proj. timelines	Test Plan Sign Off Status	TOTAL SCORE
1	00	4	3	2	4	3	16
4	33	3	2	1	3	2	11
4	44	4	4	4	3	2	17

** scores given in the table are just numbers (not calculated)

Can you please help me in deriving this scorecard.

Thanks in advance

[jpenuliar]

The community may be able to help you quicker if you attach your qv app

[sayadutt]

Hi Jonathan,

I don't have any qv yet.

I uploaded the excel from where data will be loaded.

Thanks

[manishnarang]

Considering Division and Application as dimesions.

=count({$<[Project Timelines]={'Yes'}>} [Project Timelines]) / Count([Project Timelines])

This gives you the %age of Yes. you can make these variables and apply your score logic accordingly.

BTW, off topic, how do we copy and paste some code from QV here? I had to type every thing.

[sayadutt]

Hi manish,

can you please attach the qv file itself here.

It will help me to understand.

Thanks

[sayadutt]

Hi Team,

Can you please help me here.

Thanks

[manishnarang · Accepted solution]

Check the attachment.

I have calculated “Yes %age for Project timelines”. You can formulate your logic of score over that like (if ($(=ProjTime) > 0.9 , 4, ……..) etc..