Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two columns (RE and RE_D) I want to compare the values and after do a count on the common values and count on the differenetes values and display in a table.
My table should contain:
RE | RE_D | count(commun values) | count(different values)
how can i hundle it ? , Thanks a lot
Common values: Sum(If(RE = RE_D, 1, 0))
Different values: Sum(If(RE <> RE_D, 1, 0))