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 Integ...
Need Help
lbendlin's avatar
lbendlin
Super User
4 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
4 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
    4 years ago

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

    • Mhnsan1113's avatar
      Mhnsan1113
      Frequent Visitor
      4 years ago

      Thanks for revert, so there is no workaround to the resolution? only option is the one you suggested?