Allowing Time Sum function to accept 1st argument a function

Options
Ganza
Ganza Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

I would like to ask if you may give timesum function ability to accept other function within timesum parentheses [ex: Timesum(previous(revenue),start period, end period)]. The main reason I asked this, I would like to calculate the average 3 month based on previous figure.

Demo.PNG

[Excel example]

In meantime, I would also like to ask if there is some one can give me hand on this.

Tagged:

Categories