1 Reply Latest reply on Oct 28, 2016 3:57 PM by diego.medrano

    Taking Calculated Field from one data source into another to be used as filter

    Yunus Gittham

      Hi All

       

      I have a calculated field in data source D1

      d1vcalc1 which has the following calculation

       

      IF d1calc2 = 'aaa' then 'sss' else 'ttt' end ( d1calc2 is another calculated field )

       

      I want to use the values 'sss' or 'ttt' as a filter in a second data source.

       

      So, in the second data source D2, i have added a calculated field which is called d2calc1

       

      d2calc1 contains d1.d1calc1

       

      I am trying to use that as a filter for d2 and it wont work. What am i missing?

       

      Cannot post a TWBX due to confidentiality.