5 Replies Latest reply on Sep 25, 2018 7:57 AM by krishna.amilineni.0

    Get values for the latest date

    krishna.amilineni.0

      Hi All,

       

      I am in a situation, where I need to get the value of the variable for the latest date available in the data.

      This is the sample data I have created to explain my case.

       

      I want to put employees into different buckets(high/medium) according to their weights.

      I get the counts of employees under each bucket. Here the same person is being counted twice.

      I have tried using below in two separate  calculated fields

      1. to get the maximum date

      { FIXED [MPI]: Max([Date])}

       

      2. to get the weight for that date.

      IF  [Date] = [Date(Max)] THEN   [weight] ELSE  '' END

       

      But when I use this, the same person is counted twice in the viz but I want him/her to be considered only once but with the latest weight. which is 150.

       

      Any help is appreciated.

       

       

      Thanks

      Krishna