hi guys , i have a question i do have 2 objects one is account and other one is payment . here i want to calculate every month payments how can i achive this
I would suggest you to use the cross-object formulas. Cross-object formulas are formulas that span two related objects and reference merge fields on those objects. Cross-object formulas can reference merge fields from a master (“parent”) object if an object is on the detail side of a master-detail relationship. You can reference fields from objects that are up to 10 relationships away. Cross-object formulas are available anywhere formulas are used except when creating default values.
I would suggest you to use the cross-object formulas.
Cross-object formulas are formulas that span two related objects and reference merge fields on those objects. Cross-object formulas can reference merge fields from a master (“parent”) object if an object is on the detail side of a master-detail relationship. You can reference fields from objects that are up to 10 relationships away. Cross-object formulas are available anywhere formulas are used except when creating default values.
Please see this example below
http://sfdcsrini.blogspot.com/2014/02/cross-object-workflow-in-salesforcecom.html
Best Regards
Naga Kiran