AnsweredAssumed Answered

Compare Values Table "1" to Table "2"

Question asked by surfingmussel on Sep 14, 2012
Latest reply on Sep 14, 2012 by surfingmussel

Sounds simple, but the solution is escaping me.

 

Table 1 - "FY2011" has the following values in Field:"Account"

A

B

C

D

 

Table 2 - "FY2012" has the following values in Field:"Account"

B

C

D

E

 

What is the simplest way to automatically (script, portal, whatever) to show that "in FY2011 there was account A that doesn't appear in FY12; and in FY12 there was account E that didn't appear in FY11"?

 

Essentially I want to ignore the "overlapping" accounts "B,C," and call out accounts "A,B".

 

I know this isn't rocket surgery, but I am at a loss. If its easier if all accounts are in the same table (with separate field identifying the Fiscal Year), I am cool with that, also.

 

Thanks!

 

- Doug

Outcomes