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]

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

Cheers,

Derek

• ###### 1. Re: Using Different Date Pill Depending on Measure Value

Hi Derek,

Not sure what you are aiming for but find my approach as reference below and stored in attached workbook version 9.3

• ###### 2. Re: Using Different Date Pill Depending on Measure Value

I am trying achieve this, where contributions have the 60-day rule column, but not the 60-day rule for the withdrawal. Your suggestion still seems to have values in the 60-day rule for the latter three columns, even though it should use the "As of Date" date pill where there is not 60-day rule. Hope this clarification suffices!

• ###### 3. Re: Using Different Date Pill Depending on Measure Value

Derek,

I'm slightly confused on what the final solution should be.

But, Would it be acceptable to make different tables and just put them together on a single dashboard??

• ###### 4. Re: Using Different Date Pill Depending on Measure Value

The final solution should be what my most recent image should be, where the contribution has the "60 day rule" column, but the other columns do not have that column.

Utilizing different tables would not be ideal, because the other columns need to be aligned in order for this table to be fully effective. Hope this clarifies things.