We have 3 types of "Accelerators" - Rapid, Advanced and Transformed.
Then we have 3 types of "Investments" for each Accelerator - Basic, Intermediate and Deep.
There are 2 types of modules for each accelerator/investment - "Business Strategy Consulting" and "Analytics + Reporting".
Based on the type of accelerator chosen, a multi-select picklist will have varying options populate for each of the 2 modules.
Investment type currently does not affect these options, but ideally would affect the totals as they do have different prices associated with them.
I would like 2 fields created, each one totaling the prices for each option chosen per module.
So if the user selects "Rapid" from the msp and then "Basic" from the next msp, and chooses the 1st report and the 3rd report, I want the total to calculate "35000+40000".
Rapid has 3 options for Business Strategy Consulting and 3 options for Analytics + Reporting.
Basic prices would be 35k, 40k, 40k, 30k, 30k, 30k respectively.
Intermediate prices would be 55k, 60k, 60k, 45k, 45k, 45k respectively.
Deep prices would be 90k, 95k, 95k, 75k, 75k, 75k respectively.
Advanced has 6 options for Business Strategy Consulting and 7 options for Analytics + Reporting.
Basic prices would be 35k, 40k, 35k, 35k, 40k, 40k, 430k, 30k, 30k, 30k, 30k, 30k, 30k, 30k respectively.
Intermediate prices would be 55k, 60k, 55k, 55k, 60k, 60k, 60k, 60k, 45k, 45k, 45k, 45k, 45k respectively.
Deep prices would be 90k, 95k, 90k, 90k, 95k, 95k, 90k, 90k, 75k, 75k, 75k, 75k, 75k respectively.
Rapid has 3 options for Business Strategy Consulting and 3 options for Analytics + Reporting.
Basic prices would be 35k, 35k, 40k, 40k, 40k, 40k respectively.
Intermediate prices would be 55k, 55k, 60k, 60k, 55k, 55k respectively.
Deep prices would be 90k, 90k, 95k, 90k, 95k, 95k respectively.
I would be more than happy to jump on a call or screen share to help better explain what I need.
I appreciate any and all help with this.
Thank you all.
2 answers
Let me understand first :)
you are having 3 fields.
Accelrator: I assuming this a picklist field with values:Rapid, Advanced and Transformed.
Investments:I assuming this a picklist field with values:Basic, Intermediate and Deep.
2 types of modules for each accelerator/investment - "Business Strategy Consulting" and "Analytics + Reporting". what is this? field :what data type and what values
which one is multi select picklist?
you want formula or what?
