nested if condition?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks,

Deva

Re: nested if condition?

Anil_Babu_Samineni — Fri, 28 Apr 2017 07:39:32 GMT

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')