Re: Expressions : how to get previous column value
Hi all, given the location of the time dimension, the above function will not work, but you can actually try with the before function, like this:
if(len(Amount), sum(Amount), before(Inventory))
However, I think that it might be harder to identify those cases in which you actually have zero stock and those in which you do not actually have any stock entry at all. This expression will certainly work with the sample data, but you will have to take some other considerations when you have more than one stock entry, per month and item combinations.