8 Replies Latest reply on Apr 18, 2018 4:29 AM by Tim Dines

    Creating YTD using string

    Niranjan Banarjee



      is it possible to calculate YTD using String.

      Like if I am to calculate the count of Consumer.


      I am using the below formula but showing error please help.


      YTD=sum(IF DATEDIFF('year',[First purchase date],[Choose Month])=0 AND MONTH([First purchase date])<=MONTH([Choose Month]) THEN [countd([Consumer Id]])] END)


      Error showing is cannot mix aggregate and non-agregate