7 Replies Latest reply: Feb 20, 2015 6:15 AM by Jan Heinrichsdorff RSS

    Date minus one year in table

      Hi Experts

       

      I have the following problem:

       

      I creadted a variable "VDateminus1year" with the the current date one year ago.

       

      In a table chart I have the following code: Sum ({<Jahr={$(VaktJahr)}>} ([Rohertrag_aktJ])) giving me the sum of earnings in the current year.

       

      Is it possible to change this code to sum up all earnings last year up to today one year ago, using my variable?

       

      Thank you for your help!

       

      Jan