4 Replies Latest reply on Jul 19, 2018 1:04 AM by jo.bi

    Issue Adding Variable to Sales for Future Dates

    jo.bi

      Hello data crunchers,

       

       

      I want to forecast numbers.

      For next month, I want to add a variable to current month's figures.

      Let's say i have 500 this month, and I want to add my variable (200) that will show next month figures = 700 and the month after, I want to show 700 + my variable. and so forth..

       

      I tried using DATETRUNC but couldnt figure out the right numbers/formula..

      Anyone could please help me out?