7 Replies Latest reply on Mar 26, 2020 11:13 AM by nuno.1

    LOD - Calculate Min Value And Exclude Null values

    nuno.1

      Hi,

       

      I have a calculated field "{ FIXED [Person Id]: max(if [Range] = true and [Service Date] = { FIXED [Person Id]: min([Service Date])} then [Service] END)}" here I'm getting the min service by person_id and it works perfect if service date is within the range, if not I'm getting some Null values that I don't want to show on this calculation.

       

      Screenshot 2020-03-25 at 21.57.12.png

       

      Please see attached the workbook on sheet 3 to check what is happening.

       

      Thanks.