I have 5 fields,
- List Price
- Standard Discount %
- Standard Discount Amount
- Additional Discount %
- Additional Discount Amount..
When Standard Discount % is filled , and Standard Discount Amount is empty , it calculates Standard Discount Amount based on List price.
When Standard Discount Amount is filled , and Standard Discount % is empty , it calculates Standard Discount % based on List price,
I have used isblank functionality for this and its working fine.
However the problem arises, when I edit the record, because once the process builder is fired it automatically fills in both the fields , so even if I change the value on end , it doesnt perform the calculation as expected.
Now for the fields Additional Discount % and Additional Discount Amount..
Additional Discount % is calculated on the Amount that we get after ( List Price - Standard Discount Amount)
On filling the value for the first time , everything goes smooth. However, When user tries to edit the record. the calculation does not get performed.
How do I overcome this limitation?