Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
=aggr(if(sum({<Year={'*'},Week={"*"}>}SoldQty) > sum({<Year={'*'},Week={"*"}>} OrderQty), 'Repeat',
If(StockType='Seasonal','Seasonal',
If(StockType='Terminal','Terminal',null() ))),ArticleNo)
above expression returns only null. do you have any idea how can we achieve this?
sample mock and more details.
how to combine two dimension value into one column?
Thanks,
Deva
Try only for this and look whether it works or not. If not, please attach sample qvw
if(sum(SoldQty) > sum({< Type_ID={'NB'}>} OrderQty), 'Repeat', 'NA')