nested if condition?

[devarasu07]

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

[Anil_Babu_Samineni]

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