3 Replies Latest reply: Jun 27, 2016 3:28 AM by Shivam Sarin RSS

    Find out min and max Dates and show a value only from this row

    Shivam Sarin

      Hi,

       

      I'm using these solutions but not able to get the correct answer

      1. Sum(If(Aggr(NODISTINCT Min(Date), ID) = Date, Value)) : This is giving me twice the value.
      2. Sum(Aggr(FirstSortedValue(Value, -Date), ID)) : This not giving me any result

       

      Can anybody please help me what should I do. I've attached the qvf the output should be like in Demo-Sheet 1 I've used both the formula's in demo sheet 2.