Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data only has stock mutations per date, I would like to add a dimension of the cumulative stock value in the table & in my graph per stock item.
For example the actual stock value is 423, but when I select november 2019 the stock value is 0 because there was no mutation in november 2019.
Is there an expression i can use?
You need to consider that if the stock walks the timeline it will be natural for it to appear zero in a filter that is not available.
The best practice is to resolve this in the script with a flag (bedrag_current = 1) pointing out that this is the most current stock and then fetch it with Set Analysis, regardless of the selected period or bring last month's stock to the current one until there is a new mutation, based on inventory concept per month.
Set Analysis with flag in case:
Sum(
{<
MonthYear =,
bedrag_current = {1}
>}
bedrag
)