Fixed LOD in Cognos

[kmrosan]

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