4 Replies Latest reply on Nov 21, 2016 12:45 PM by derek.leung.0

    Using Different Date Pill Depending on Measure Value

    derek.leung.0

      Hi All,


      Here, I have for measure values (contribution, transfer-in, transfer-out, withdrawal). The problem here is that I want to use different date columns depending on the measure value. Specifically, I want to use the "RRSP Year" string/date column for contribution only, and use the "As Of Date" for transfer-in, transfer-out, and Withdrawal.

       

      So the logic would something be like:

       

      IF [measure values] = [portfoliocontribution]

           THEN [RRSP Year]

      ELSE

           [As of Date]

      END

       

      But this does not work because measure values / names is not a pill you can do calculations on. Any suggestions or insight to solve this problem would be greatly appreciated

      Different Dates Depending on Measure Value.png

       

      Cheers,

      Derek