8 Replies Latest reply on Jul 9, 2018 11:37 AM by alex.zapherson

# Return value based on specific criteria

Data is structured as follows:

Product ID        Seller ID        Price

Product ID 1     Seller ID 1     \$2.00
Product ID 1     Seller ID 2     \$1.50

Product ID 1     Seller ID 3     \$1.75

Product ID 2     Seller ID 4     \$20.00

Product ID 2     Seller ID 5     \$21.00

Product ID 2     Seller ID 6     \$20.50

I need to figure out a way to return the price a specific seller (for example the price seller 1 is selling at) for all of the sellers on product 1. Then return the Seller 1 price for all sellers on product 2.  See below for what I would like to have returned.

Product ID        Seller ID        Price       Calculated Field (Repeat Seller ID 1's Price for all sellers in separate Field)

Product ID 1     Seller ID 1     \$2.00       \$2.00
Product ID 1     Seller ID 2     \$1.50       \$2.00

Product ID 1     Seller ID 3     \$1.75       \$2.00

Product ID 2     Seller ID 1    \$20.00      \$20.00

Product ID 2     Seller ID 5     \$21.00     \$20.00

Product ID 2     Seller ID 6     \$20.50     \$20.00

If you have any questions please let me know, any help would be greatly appreciated, thanks!

• ###### 1. Re: Return value based on specific criteria

{FIXED Product ID:SUM(IF Seller ID="Seller ID1" THEN Price END)}

• ###### 2. Re: Return value based on specific criteria

Deepak,

That has gotten me closer, and I have used this calculation instead: {FIXED [Product ID]:MIN(IF [Seller ID] = "Seller ID1" THEN [Price] END)}

However Price can change by day and I am not coming up with the matching price, and I need to make sure it is fixed to the date and product ID, I apologize for not mentioning this in my original post.

• ###### 3. Re: Return value based on specific criteria

Can you paste your data set in excel, because I can't copy from what you pasted earlier. and also let us know which date you want price to be fixed.

Thanks

Deepak

• ###### 4. Re: Return value based on specific criteria

Sorry about that here is a sample data set with date included. I am looking to have the price to be fixed to whatever Seller ID 1 has price listed at for that specific day. Should make more sense in the sample data set but let me know if you need any further explanation.

• ###### 5. Re: Return value based on specific criteria

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 6. Re: Return value based on specific criteria

I just figured this out as well, excellent. thank you!

• ###### 7. Re: Return value based on specific criteria

It was easy, I could have said you to add Date in Previous Formula, But I was Trying to make sure if you want to add more complexity so that I can Respond

• ###### 8. Re: Return value based on specific criteria

Yes haha I forgot to specify this, thanks for your help!