Hi,
First off, any help is appreciated. I work in both Tableau and Cognos. I have a table that consists of for instance Member Number, Date 1, and Date 2. I have completed a FIXED LOD calculation in Tableau that I'd like to carry over to Cognos. The expression in Tableau is:
{FIXED[Member Number],[Date 1]:MIN(if ([Date 2]>[Date 1]) then (Date 2]) end)}
This calculation gives me the minimum of Date 2 after Date 1 FOR the Member Number and Date 1. We have many Member Numbers, Date 1, and Date 2.
Any ideas how I can achieve this with a Cognos expression? I'd rather stay away from a separate SQL statement to get the result.
Thanks, Kevin