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
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?