Regarding values %

[d_koti24]

Hi,

I have 2 tables Tab1,Tab2

tab1:

devA	devB
1	a
2	b
3	c
4	d
5	e

Tab2:

prodA	prodB
1	a
2	b
3	c
4	d
6	f

i want Values Match % in both fields in both fields

o/p like this:

dev	prod	Match%
devA	prodA	90%
devB	prodB	90%

how to achive the match values % in fields?

Regards,

kd

[sinanozdemir]

Hi,

Maybe something like this:

Although, the true percentage of the match is 80% for both:

Hope this helps.