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

    LOD - Calculate Min Value And Exclude Null values




      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.