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

    Using Different Date Pill Depending on Measure Value


      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]


           [As of Date]



      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