Data Investigation

[Simon1187]

Hi there, 

I am trying to achieve when Contract_id has two or more product_id then for getting total it considers Total price, if not it considers paid . Could you please help me with that? 

Thanks, 

Sample Data is below: 

[binay2448 · Accepted solution]

Find my solution for this problem..

[AngelosPachis · Accepted solution]

Hi @Simon1187 ,

Here's how you can do it. First you can use a summarise tool to count the number of products per contract and then use a filter tool to split your records to those that have only one or two or more.

Then you can configure your summarize tools to use the appropriate fields and join your data back together

Hope that helps,

Angelos