Score card based on logic

[rammuthiah]

I have a requirement given below. Kindly check for the rule. I need the Score as like in the given table. Up to "Check" I did in back end. And struggling to get Score. Any Idea? In back end or in front end

Scenario 1	Rule
Supplier/Customer	C1	C2	Check	Score	if any "Check" for 1A is False, then FALSE for both 1A and 1B in Score
1A	100	100	TRUE	FALSE
1A	200	200	TRUE	FALSE
1A	300	250	FALSE	FALSE
1B	300	300	TRUE	FALSE
1B	250	250	TRUE	FALSE
1B	600	600	TRUE	FALSE
Scenario 2
Supplier/Customer	C1	C2	Check	Score	if all "Check" for 1A is True, then True for 1A and if any "Check " for 1B is False, then FALSE for only 1B in Score
1A	100	100	TRUE	TRUE
1A	200	200	TRUE	TRUE
1A	300	300	TRUE	TRUE
1B	300	300	TRUE	FALSE
1B	250	250	TRUE	FALSE
1B	600	500	FALSE	FALSE

[OmarBenSalem]

Can u share how u'll do it in this case plz?

[rammuthiah]

Consider 1 as Project # and A as Customer and B as Company. Now I am comparing the Project Sub Division of 1->A vs B.

If Customer Satisfied(A-True) -Score won't affect the business even if any fault happens internally in Company(B-TRUE/FALSE) - Scenario 1(Only B will be FALSE)

If Customer not satisfied(A-FALSE) -Score will affect the Company even no faults in Company(B-TRUE) - Scenario 2

(Both A and B should be FALSE)

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others