if Condition

[devarasu07]

Hi,

Goal:

Want to show the Article only when SoldQty>0 and soh>0

=if(aggr(sum(SoldQty),ArticleNo)>0 and aggr(sum(soh),ArticleNo)>0,ArticleNo)

(if i use above expression any not working as expected - currently it just works soldqty>0 condition)

Thanks,Dev

[Anil_Babu_Samineni]

What if we have written this? where you are implementing

If(aggr(sum(soh),ArticleNo)>0,ArticleNo)

[devarasu07]

Hi Anil,

I need to apply both measure condition (sum(SoldQty)>0 and sum(soh)>0) . it's article level report. Tks

if i use only one measure in that if condition its working fine. need to apply both for my report requirement .

Note: if either one measure has <0 then it should display the article, i just don't show article when both measure <=0.

Thanks, Dev

[Anil_Babu_Samineni]

That case, It should work.

=if(aggr(sum(SoldQty),ArticleNo)>0 and aggr(sum(soh),ArticleNo)>0,ArticleNo)

Would you provide sample? And soh is all lower cases. If one condition works it should work for two conditions

Note: Here, Your condition seems only get article when the condition value is >0. Then, How you are expecting <0 will accessible

[avinashelite]

share the sample app ...will check and let you know