2 Replies Latest reply on Oct 17, 2018 5:35 PM by matias gripe

    Help with FIXED calculated field

    matias gripe

      Hi everyone,

       

      I need help with a calculated field im creating. I have and ID field, stage, Start (date), End (date), a date parameter, and a "Condition" calculated field.

       

      The result of this should be a 1, for each ID, where the parameter date is contained between the start and end date. I have this working, but i'm missing the second part.

       

      The calculated field (condition) also needs to meet another condition, which is that the 1 should only be in the max stage (for each ID) that meets the previous date conditions.

       

      In the next image I have a 1 where date condition is TRUE , but cant make the 2 conditions work together in the same calculated field. I have tried FIXED and INCLUDE level of details calculations, but nothing is working till now.

       

      Im attaching a workbook example.

       

      Thanks everyone for your help,

       

      Best regards