8 Replies Latest reply on Apr 27, 2018 4:08 PM by Kevin Esther

    LOD Find The First Instance of volume > 20 then Return the Age

    Kevin Esther

      Hi,

       

      I have created calculated field using a Fixed LOD. I have managed to write LOD to return the age given the below conditions

       

      Find == (Level = Level AND Volume > 10)

       

      data.png

       

      However the data test data was at the above level however the original  = 1 record per row.

       

      I have also have built sets as there about five columns of data that make up the department and level so this is why I have set in and out.

       

      I might just be overthinking this and cover complicating the calculation.

       

      Reason went with LOD is that the view will be changing so thought this would be the best approach.

       

      Thanks

      Kev