Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All.
I trying to create Aging Stock Report ( After 1 - 2 - 3 -....-12 Month )
the Aging after 1 month = the purchase month before
the Aging after 2 month = the purchase 2 month before
the Aging after 3 month = the purchase 3 month before
....
...
..
( we continue calculate one month before until we arrive the current stock Quantity then 0 )
I make the formula and everything is okay..
I want to know the correct total aging Or the total aging for multi Items.
please help me.
found attachment example
Hi, You need to use aggr to get this to work. Do like this in all expressions
sum(aggr(if(
(if(sum(Purchase)>sum([Current Stock])
,sum([Current Stock])-sum({$<Month={'Dec','Nov','Oct','Sep','Aug','Jul','Jun','May','Apr','Mar','Feb'}>}Purchase)
,sum({$<Month={'Jan'}>}Purchase)))<0
,0,
if(sum(Purchase)>sum([Current Stock])
,sum([Current Stock])-sum({$<Month={'Dec','Nov','Oct','Sep','Aug','Jul','Jun','May','Apr','Mar','Feb'}>}Purchase)
,sum({$<Month={'Jan'}>}Purchase) )),[Item Code]))
Hi, You need to use aggr to get this to work. Do like this in all expressions
sum(aggr(if(
(if(sum(Purchase)>sum([Current Stock])
,sum([Current Stock])-sum({$<Month={'Dec','Nov','Oct','Sep','Aug','Jul','Jun','May','Apr','Mar','Feb'}>}Purchase)
,sum({$<Month={'Jan'}>}Purchase)))<0
,0,
if(sum(Purchase)>sum([Current Stock])
,sum([Current Stock])-sum({$<Month={'Dec','Nov','Oct','Sep','Aug','Jul','Jun','May','Apr','Mar','Feb'}>}Purchase)
,sum({$<Month={'Jan'}>}Purchase) )),[Item Code]))