4 Replies Latest reply: Aug 30, 2018 4:09 AM by Carlo Menta RSS

    Last value

    ruti t

      Hi everyone,

       

      I have table with the following fields: ID, P_Year , P_Status

      I want to create also calculate field named: 'P_Last_Status' that display the status of last year for each ID:

       

      IDP_YearP_StatusP_Last_Status
      112015Success
      112016FailureSuccess
      112017GoodFailure
      222015Success
      222016GoodSuccess
      222017SuccessGood

       

      I also want to display by default only the record of max year (in this example only the records of 2017) unless the user choose value in field P_Year then the table will filter according to the selection..

       

      I try to calculate the field P_Last_Status with function above() but it's not working because the filer..

       

      Could you please advise how can I do it?

       

      Thank you..