nathan_rudman 
-
Re: Last Non-Zero Occurrence
As mentionned, you'll need to use the summary type "Closing Balance". But first you'll have to create a technical line item that will take the latest non 0 value forward with the …2 -
Re: Reverse Cumulate Alternative?
one solution is: test all possibilities with a movingsum and a numbered list: extracting the result with first non blank: here's the list of possibilities: there might be an easier way if we are…2 -
Re: Last 12 months SUM and Actual Version
for the version part, it really depends how you have built your model. If you have built it with native Anaplan versions, then you should simply have the switchover on your forecast in which case the…2 -
Re: PREVIOUSITEM() - PREVIOUS() on a list
time is the only solution to avoid the circular reference. What avander and Yelena expose here only allow you to bring 1 previous value. We use Yelena's solution often enough (especially for lis…2 -
Re: Best way to handle validity of products prices
I personally prefer to store data in a dimensional way, not transactional, I think that is just easier to use in Anaplan. That means solution one. You don't need to update price every month. You…2
