1 Reply Latest reply: Jan 3, 2013 11:15 AM by Adam Wilson RSS

    setanalysis due date analysis



      I have a setanalysis problem, I want to calculate the sum of the amounts that are not due (DueDate < today). Using this wonderfull community I have found some formula's but none of them seem to work for me.


      What is wrong with this one? : Sum({$<DATE(DueDate)= {"<$(=Today()"}>}Amount)


      Many thanks for your help

        • Re: setanalysis due date analysis
          Adam Wilson




          You cannot use functions on the fieldname within your set modifer only on the actual selection, define the data type in your load script i.e. Date(DueDate) as DueDate


          You were also missing a closing parentheses.


          The below should result in a sum of Amount where DueDate < Today