3 Replies Latest reply on Jun 27, 2018 3:52 PM by Hari Ankem

# Customer that bought A but still haven't bought B

Hello community!

Oversimplifying, I need a calculated field that would flag me:

Who are the customers that bought product A and still haven't bought product B (kind of upgrade).

Note: I don't want to see customers who bought product A and already bought product B (I don't need to follow up with them anymore).

Note2: 'Product C' is when the customer buys the upgraded version right away (less common).

In other words, for the same customer:

When the variable [Product] = 'Product A' (non empty for amount)

AND [Product] = 'Product B' (empty/null)

Makes sense? Really appreciate any help!

 Date Customer Name Product Amount(\$) OUTCOME(calculation) October 2017 ABC Product C 2,000 SOLD Sept 2016 CUSTOMER1 Product A 900 (blank) April 2018 CUSTOMER1 Product B 1,100 SOLD2 May 2018 DEFG Product C 2,000 SOLD January 2018 IMPORTANT2 Product A 900 FOLLOWUP January 2018 IMPORTANT3 Product A 900 FOLLOWUP
• ###### 1. Re: Customer that bought A but still haven't bought B

Here you go:

Hope this helps.

1 of 1 people found this helpful
• ###### 2. Re: Customer that bought A but still haven't bought B

Wow thanks so much Hari! You are awesome. I would never have guessed that I needed to use FIXED and COUNT formulas.

• ###### 3. Re: Customer that bought A but still haven't bought B

You are welcome.