2 Replies Latest reply on Jun 26, 2018 4:16 AM by sudheer.kumar.5

    How to grab a value for a certain date in calculated field?

    Pak Hang  Leung

      Hi all

       

      Now I have a table as follows

      Date Value
      1-Jan-2017100
      1-Feb-2017150
      1-Mar-2017180
      1-Apr-2017140

       

      So what I want is to save the result from Average where data equals to 1-Jan to 1-Apr in a calculated variable.

      How should I do that? Many thanks for your help.