2 Replies Latest reply: Nov 14, 2016 7:13 AM by Juan Carlos Neufeld RSS

    In an expression, find a specific record in a table

    Juan Carlos Neufeld

      Hi!

      In a chart expression, I want to get a specific record in a table.

      The table contains two fields: [date], [value].

      Example:  2016-11-12, 120

                      2016-11-13, 145

                      2016-11,14, 208

                    

      Using today's date, I want to get the corresponding value in the table. (If today is 2016-11-13, I want to get the value 145.

       

      Thank you in advance for your help.