4 Replies Latest reply: Dec 7, 2017 4:57 AM by Bruno Paulo RSS

    Compare 2 strings in set analysis

    Bruno Paulo

      Hi community,


      I have the following table:


      FieldA     |     FieldB     |     FieldC

      boss               boss               4

      boss               worker            3

      boss               boss               3

      boss               worker            4

      worker               boss               1

      worker                worker          4


      So i want a field where i do the avg of field C when Field A= Field B


      I tryed this Sum({$<FieldA= p(FieldB)>}FieldC)/count({$<FieldA=p(FieldB)>}FieldC)


      and this


      I tryed this Sum({$<FieldA= FieldB>}FieldC)/count({$<FieldA=FieldB>}FieldC)

      Neither worked.

      Any ideas?
      Thanks in advance

      Best Regards

      Bruno Paulo