Need a measure to identify the PO has only one category

[thulasi1989]

Hi team,

I have Purchase order with mutliple lines. Each line are categorized into direct category or indirect category.

Senario 1 - Purchae order contain 6 lines, 4 are direct category and 2 are indirect category

Senario 2 - Purchase Order contain 6 lines all are indirect category

Senario 3 -  Purchase Order contain 6 lines all are direct cateogory.

 From the above senario i need to identity the the PO's which contain only indirect category.

 I need to implement this logic for 2000K Purchsae order and identify the indirect category PO.

[v-shex-msft]

Hi @thulasi1989 ,

Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng