7 Replies Latest reply: Apr 22, 2017 11:08 AM by Agnaldo Neves RSS

    I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

    Agnaldo Neves

      Returns me due date to date today: It's OK

      Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}, Diar={'<=$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC) 


      I need you to bring me to the current month.?

      Example:

      Month        Valor

      Abr            125.000,00

      Mar           854.000.00

      Fev           822.000,00

      Jan           322.000.00




      Example set analysis: It's OK

      Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}, Diar={'<=$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC) 

      2017-04-21_21-49-48.png