11 Replies Latest reply: May 26, 2017 6:10 AM by sonygot g RSS

    sum to current date selection

    damian Nyakoe

      i am trying to add expenditure to current selection using: =sum({<[A/C Type]={'Direct Staff Costs*'}, FinResultsDate={'>=$(=date('01/09/2016','MMM-YY')) <=$(=date(max(FinResultsDate),'MMM-YY'))'}>} [USD amount])

       

      My year starts in september. Anyhelp?