You need to sign in to do that
Don't have an account?
![Jem57 Jem57](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Iteration loop based off value in custom field
I have 10 custom fields that I need to calculate values for. I will only be calculating a certain number of them based on the number in another custom field. For example if the value in number_of_parts__c is 6, I would only need to calculate the values for the first 6 custom fields and not the rest. How can I use the value in a custom field to run an iteration loop? Or is there another way to do this?
Thanks
hmmm... how's this....
Sort of. The logic is more like this
Total_cost_1 = parts_month1 * cost_month1
Total_cost_2 = parts_month2 * cost_month2
Total_cost_3 = parts_month3 * cost_month3
.
.
Total_cost_10 = parts_month10 * cost_month10
but, I only need to do this up to the number in the number_of_parts__c field. So if the value is 5 then last calculation that will be run is Total_cost_5 = parts_month5 * cost_month5
I'm figuring there must be a way to increase the iteration after each calculation, but I'm just not sure of the proper code to do that.
ok.. so how about this: