Forum Discussion

Mhnsan1113's avatar
Mhnsan1113
Frequent Visitor
4 years ago

logic building

Hi  

Have created this the below calculated column logic and used in table below

s_descs = if(tbvw_overdue_order_leadtime_vw[vendors]="WESCO INTEGRATED SUPPLY INC" && [plant]="6500"  ,"Wesco Integrated Supply", if(tbvw_overdue_order_leadtime_vw[Ariba/Non-Ariba]="Ariba" && ([plant]="6500"||[plant]="6540"),"Ariba Vendors").the output is below.
But the challege is the Ariba vendors includes wesco integrated supply count. I want Ariba vendors count should show  2888+500= 3388 and Westco integrated supply as 500 . 

Request if someone can help and guide

REgards

 

Mohan
Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Don't do that. You would introduce data duplication and confuse your users. 

     

    Instead, let the matrix visual do the work. Create a Group "Ariba vendors" based on your logic and then show Wesco in the hierarchy below,  as one of the Ariba partners.

    • Mhnsan1113's avatar
      Mhnsan1113
      Frequent Visitor
      3 years ago

      Thanks for reply,  Above table "Ariba vendors" has sub-vendor and wesco is one of the sub-vendor for Ariba, and Wesco is also a parent vendor and sub vendor too. When logic build for Ariba tbvw_overdue_order_leadtime_vw[Ariba/Non-Ariba]="Ariba" && ([plant]="6500"||[plant]="6540").Wesco is getting Captured in Ariba, But cliet wanted that count should get added in both. Is there any workaround or logic to build. Please suggest 

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Take my advice or leave it - I would handle that in the source data.