5 Replies Latest reply: Aug 19, 2014 12:25 PM by Alfredo Guerrero RSS

    Set Analysis where one field equals another field

      I am trying to get a sum of values where two ID fields from different tables have the same value.

       

      For example, I can get a valid value if I hardcode an ID like "MTG2" below:

      sum(total {$<ProdID = {"MTG2"}>} Est_Cost)

       

      But what I want is to get the sum for that row where ProdID equals another field called AltProdID (in a different table, but with the same values as ProdID).

       

      The closest I found in the help documentation was something like this:

       

      sum(total {$<ProdID = {$(#=Only(AltProdID))}>} Est_Cost)

       

      But that does not seem to work and just returns zero.