Score Card Logic

[rammuthiah]

Need logic for this below image. I tried but couldn't make it possible. Please find attached qvf

1 - CustomerID

A - Customer

B - Internal

If I select any customer, it should be shown like below scenario(CustomerID : 1 or 2 or 3....)

Scenario 1 : If Check for any A is X-> Score 1 = X , Score 2 = X

Scenario 2 : If Check all A is O-> Score 1=O and

If Check for any B is X-> Score 2= X

[Qrishna]

Could you please be more spcific and clear?

[rammuthiah]

For each project #(for eg. 1 has A and B. If A has any X by comparing the value C1 and C2, Then Score 1 and Sore 2 shoould be X, if no X for A and X for B, then Score 1 should be O and Score 2 should be X)

[rammuthiah · Accepted solution]

I have done this logic.

By using segregation of Check based on the value and merge it in a single table solves all the problem.