1 Reply Latest reply on Jul 11, 2017 11:57 AM by Patrick A Van Der Hyde

    How to create month breakdowns

    Alex Martino

      I have this formula that captures the difference between two seperate dimension dates. How can I have all numbers after 12 be grouped into 1 month number. So 1-11 and then 12+?

       

      datediff('month',datetrunc('month',[start month]),datetrunc('month',[paid month]))+ 1