8 Replies Latest reply: May 15, 2015 6:19 AM by marisya chizhikova RSS

    current date minus 7 days

      Hi all!

      I am struggling with such expression (percentage of rate's changing between 7 days):

      1- Avg(index_1)/Avg({1<date = {'current date minus 7 days'}>}index_1)

       

      Could you help me!?

       

      Thanks! Marina