Logic to Find Value for Score1 and Score 2

[rammuthiah]

I have to find score based on the logic :

If Customer 1 and A has 'O' in Check, but in Score 2 has 'X', then Score 1 total  should be 'O' and Score 2 total to be X.

If Customer 1 and A has any 'X' in Check, Then Score 1  and Score 2 total to be X.

Message was edited by: RAM MUTHIAH M

Message was edited by: RAM MUTHIAH M

[chinnuchinni]

can please attach the sample data and clear o/p which will you required ?

[agigliotti]

what do you mean with 'A' ?

[rammuthiah]

It's just a flag to indicate where the data is from

[agigliotti]

please show us what are the expressions you are using for SCORE1 and SCORE2 columns.

[rammuthiah]

Please find attached qvf

[agigliotti]

what is your business logic for SCORE1 and SCORE2 columns?

what is your expected result?

[rammuthiah]

That I highlighted in the image in total column as 'O' and 'X'

[agigliotti]

yes I see but what's the logic behind that results ?

[rammuthiah]

If A affects 'X' it reflects to 'B'(then Scroe1 and Score2 ->'X') also See 2nd image.

If Adoesn't affect 'O', but B->'X', then Score1 ->'O' and Score2'X'