6 Replies Latest reply: Nov 5, 2015 7:49 AM by Sunny Talwar RSS

    syntax set analysis

    Kilian Riera

      What i do wrong?


      this sentence is correct and it works. It grabs all the data (1) instead of using the selection ($), from all the facts matching groupID 3 and with an start time lower or equal to 01/11/2015 00:00:00 then it Sum it.


      Sum({1<GroupID={'3'},StartTime={'<=01/11/2015 00:00:00'}>}Valor)


      What i want to change is to make the 01/11/2015 00:00:00 automatic. i mean, put the current floor month start date. That way every new month i'll have the previous month data.


      But i've tryed a lot of things and none seems to work.


      Any Idea?


      huge thanks.