The "amount deal" is updated with the sum of the Product Total prices. However, as we are working in the finance industry, I need to calculate the product price which is the monthly interest.
I can create new fields on the deal (because I can not create a property with a calculation type field on the product):
- "Interest rate"
- "Loan amount"
- "Term"
- "Monthly interest "(calculation format)
This "monthly interest" is my Product Price. How can I update the product "unit price" and the deal "amount" (we can not change the "Amount" property)?