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



      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)




      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.