There are two tables.
1.Commision percentage based on the max and min ranges of the price of the product.
The problem is I have to calculate the commission amount based on the values in table 1.We cant hard-code it because the percentage may change in table1.
Solved! Go to Solution.
Suppose the Commission percentages are:
Low Value Max Value Percentage
0 100000 2
100001 500000 2.5
500001 1000000 3
And I have given a table which contains various cost prices.Now the objective is to calculate the commission amount using these values.And one constraint,these values should not be hard-coded.That means these values may be changed.I heard something called dynamic bucketing using macros.Does that help?If yes,then how can you upload fields from the sheet to the macro?
And I will also provide some sample data for which I need to calculate the commission values.
Sales Id Cost
And the problem is no of buckets may also change,so is there a way in which the data in excel files(where the data is changed) can be loaded as fields into the macro and corresponding updates are done when the data is reloaded.
I have also seen one post on dynamic bucketing,is this helpful in solving my problem?The problem I am facing is how to upload fields from the sheet into the macro and dividing into buckets.
I would like to ask you more about this interval match.Suppose I want to check the interval for a changing variable in the sheet itself.
For example,Take sales ID's 1,2,3,4 .Suppose they belong to January.I would like to check the interval based on the sum of the costs of those sales ID's.i.e.,I should check the interval based on a variable that changes according to the selections.Can we do that without using macros?
I have started a new Thread and attached some files for examples.
Thanks and Regards,