1 Reply Latest reply: Nov 21, 2011 9:24 AM by Stefan Wühl RSS

    Set analysis nested within a set analsysis expression

      Hi All

       

      I am having issues with this set analysis expression. The expression has 2 conditions. the second conditions is another set analysis expression. This expression works on its own, but not within this expression. I think the porble lies in the way i am trying to input the set but i just can figure out the right way.

       

      Could somebody help?

       

       

      Min({<[Claimant Status Description]={'Settled'}, '$(Max({<[Claimant Status Description]={'Open'}>} [Claim Transaction Done Date]))'  >} [Claim Transaction Done Date]) 

       

       

      I look forward to your replies

      James

        • Set analysis nested within a set analsysis expression
          Stefan Wühl

          I believe you need to specify a field you want to limit the max(...) with, maybe the [Claim Transaction Done Date] field?

           

          Try

          Min( {<

          [Claimant Status Description]={'Settled'},

          [Claim Transaction Done Date]= {'$(=Max({<[Claimant Status Description]={'Open'}>} [Claim Transaction Done Date]))'}

            >} [Claim Transaction Done Date]) 

           

          But I am not sure if this is right, maybe you could describe what you want to achieve?