SimonA123 Posted April 11, 2018 Report Share Posted April 11, 2018 There are two options available for my clients to choose: Number of Locations, and Number of Employees. After they choose those two fields, they get what it will cost them for the annual plan, and what it will cost for the monthly plan. So essentially, I have two field to choose from, and then two fields that I want to show up depending on what the first two fields are that they chose. The pictures listed below give you an idea of what I want. (I know it won't look the same) I want those first two options: Locations, and Employees: on the first page, and then I want the two separate prices for each Monthly and Annually. I can give you the data, but that is company sensitive, so just let me know if you can help! Thanks Quote Link to comment Share on other sites More sharing options...
MayMusic Posted April 12, 2018 Report Share Posted April 12, 2018 Based on the selection and Location you can provide Monthly and Annual prices. What would be the calculation for that? Do you have a lookup table for this? You do not need to share your data. Only sample data would work. Please provide an example. Quote Link to comment Share on other sites More sharing options...
SimonA123 Posted April 13, 2018 Author Report Share Posted April 13, 2018 Quick update, we only need one number in the results. That number is the Monthly price. (We dont need annual anymore) So that value in the picture is a great example. Quote Link to comment Share on other sites More sharing options...
SimonA123 Posted April 13, 2018 Author Report Share Posted April 13, 2018 This problem was completed. Thank you for your willingness to help. Quote Link to comment Share on other sites More sharing options...
MayMusic Posted April 13, 2018 Report Share Posted April 13, 2018 You are welcome I would appreciate if you can share the solution with me Quote Link to comment Share on other sites More sharing options...
SimonA123 Posted April 16, 2018 Author Report Share Posted April 16, 2018 I originally had the data all lined up in a horizontal line, but i needed to have the data arranged vertically with: number of employees in one column, number of locations in another, and the price for each in the third column. I had to repeat the number of employees for each number of locations, to make this work. If you have any questions just let me know. Quote Link to comment Share on other sites More sharing options...
MayMusic Posted April 24, 2018 Report Share Posted April 24, 2018 Thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.