You need to sign in to do that
Don't have an account?
Susy Fong
Total Amounts repeat on each line
Have a formula which calculates the total expense amount as each item is added. However, the total keeps repeating on each line, how do I get the total amount to only appear on the last item added? (This total appears under the related list)
Opportunity_Name__r.Opportunity_Total_Exp__c
Opportunity_Name__r.Opportunity_Total_Exp__c
I don't think there is any easy way to do what you're asking.
It's unusual to be putting the total for all expenses on each expense, usually you would just show this as a field on the parent opportunity.
The only way you could show tht total but on just one record would be something like a flow. This would sum all the values from all expenses under the same parent opportunity, then cleared those values and saved the new total to the expense that just ran the flow. A very long and convoluted process.