5 Replies Latest reply on Jun 15, 2018 5:55 AM by Rod Nault

    Calculation Help Please

    Rod Nault

      I want to create an indicator where if the same 'PolNum' shows up more than once AND at least one of the 'CurrentIndicator' values is 'Yes' then all records for that policy number would show as Yes.

       

      In the sample below, the 'CurrentIndicator' would show 'No' for 'PolNum' = 'A123' where the 'Product Type' = 'Rider' BUT because one of the values ('Product Type' = 'Product') is 'Yes' then all records for that 'PolNum' should be 'Yes'

       

      I have tried LODs and other manipulations but I can't figure it out.  Can someone please help me?  Packaged workbook is attached.  Thank you !!!

       

      Rod