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

    Creating YTD using string

    Niranjan Banarjee

      Hi,

       

      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