We are reviewing our sales history and pricing to determine if we could sustain a price increase.
We want to know if we increase the price of Item/Product #1 ("PRP") and a Customer was invoiced for additional Item/Products, what is the $ amount of our risk of losing the Customer for all the Items/Products (Calcs & Forms & STE) purchased, if they cannot sustain a price increase on one Item/Product #1 ("PRP").
We need to understand a few things if we target our Item/Product #1 ("PRP") for an increase:
- How many Customers have purchased Item/Product #1 ("PRP")
- What is the Base Price for Item/Product #1 ("PRP")
- How much did the Customer pay for Item/Product #1 ("PRP")
- If a Customer has Item/Product #1 ("PRP"), include all other Items/Products (Calcs & Forms & STE) that the Customer purchased.
I can easily deliver a transaction (Invoice lines) saved search that handles the first 3.
I need a Formula (Text) if Customers were invoiced for any PRP, display all Invoice lines for each Customer that was invoiced for Item: sub of>Calcs & Forms & STE.
I have looked through a few topics and read through the User Community Topics:
Saved Search - Return all lines when 1 line meets criteria
Case When value is x OR y, then z
CASE WHEN conditions
100 Ways to Use Formula Fields
SuiteAnswers: Search Formula Examples and Tips
I was looking for a formula I could adapt to my fields but I can't find anything close enough.
Does anyone have any Suggestions?
Thanks.