12 Replies Latest reply: Oct 9, 2011 10:54 AM by Jonathan Dienst RSS

    Compare Data of Today to Yesterday

      Hey Guys, first post...

      small question though, beginners one :-)

       

      I want to SUM the COST for a certain day, using the day i currently have... in other words, if i select the 2nd of july i want to sum the amount of the 1st, if i select the 1st i want to sum the 30/06 and so on...

      I was sure it's going to be simple but im totally stuck!

       

      I tried this with no luck: =sum({<Day=Date(Day-1)>} Cost)

      (Day is my field of date)

       

      Can you please help me?

      thanks!

      Zohar.