Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if ((Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty ))<>0,
(Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty)),
aggr(Above( Sum({<Article_No={'*'}-{''},Seasonwise={'Current'}>} net_qty )),Entity,GLZone,Store_Code,Rolling_Month))
aggr function not working in this. if i am trying 1 in else condition it is showing 1 , if i am trying only above statement it is working for first two months. any1 can help
Would it be possible to share a sample?
Please find the attachment. I want closing stock current to be copied in opening stock current of next month