logic building

[Mhnsan1113]

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

[lbendlin]

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]

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]

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

[Mhnsan1113]

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