I am calculating sales incentives of Sales officers of a Car Dealership company. I have created multiple calculated fields for all types of incentives which gives accurate results. I created a Total incentive calculated filed which calculate the total of all type of incentives correctly. The problem is when i remove Model names from the table then all calculated fields are getting wrong result. Please help..
(Correct Output) With Model Name:-
(Incorrect output) without Model:-