Hi, I have an opportunity table and left keep a competitor table, One opportunity may has 2 competitors. When I calculate order value from opportunity. The order value of opportunity which has 2 competitors will be calculated twice. For instances: ID: 1001 opportunity order value is 100 which has 2 competitors, and opportunity table left keep competitor table. If I sum(Order value), it will be 200. How to fix it?
