2 Replies Latest reply on Jan 29, 2016 9:33 AM by Manjula Raj

    How to calculate with reference field

    Manjula Raj

      Hi,

       

      I've xls data with the columns Date, 15 Day Val, 30 day Val. Dates will be weekly dates. I want to calculate If next week 15 day val > this week 15 day val then sign is '+'  else '-'.

       

      How can i calculate this. Please help me to find the solution.

       

      Thanks in advance.

        • 1. Re: How to calculate with reference field
          Manjula Raj

          Hoping giving sample data will help you guys to answer me.

           

                 

          Date15 Day Val 30 Day Val
          15-01-2016-1.29-0.37
          15-01-2016-0.640.32
          15-01-2016-0.63-0.66
          15-01-20160.270.76
          15-01-2016
          15-01-2016-1.670.90
          15-01-2016-1.19-0.25
          15-01-20160.170.54
          15-01-20160.191.34
          15-01-20160.542.23
          15-01-20160.150.16
          22-01-2016-1.181.15
          22-01-2016-0.121.48
          22-01-2016-0.40-0.45
          22-01-20160.400.90
          22-01-20160.430.27
          22-01-2016-0.613.42
          22-01-2016-0.720.34
          22-01-20160.270.04
          22-01-20160.521.83
          22-01-20160.800.96
          22-01-2016-0.401.63

           

          Here i want to do something like

           

          Max([Date]) [15 Day Val] > Min([Date]) [15 Day Val] Then '+' else '-' end

           

          I don't know how to get the above thing. This syntax will not work. I want to know the way how can i get the result for this?

           

          Please help me.

          • 2. Re: How to calculate with reference field
            Manjula Raj

            Please help me.

             

            The question may be silly but i'm new for it. Please I’m looking for your help.