From the table below i have a profit figure on multiple lines. I only want it to output the £1,785.5 value in a calculation based on the fact the VM_SK_SORDER column has the same value.
| VM_SK_VEHICLE | VM_SO_CONFIRMDATE | VM_SO_BRANCH | VM_EN_SALESEXEC | VM_PR_DESC | VM_PR_DLRDESC | VM_SK_DESC | VM_VE_MANUFACT | VM_SO_REGNO | VM_SK_VIN | VM_SK_VTYPE | VM_SK_STATUS | VM_SK_TOTALPROFIT | VM_SK_SORDER |
| 15731 | 18/01/2022 | 0002 | alac | Adopted | Adopted | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | Consigned | Consigned | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | Fully costed | Fully costed | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | Invoiced | Invoiced | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | Memorandum | Memorandum | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | On order | On order | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
| 15731 | 18/01/2022 | 0002 | alac | Closed | Closed | Daily 35C14D Crew Cab TD 3750 | IVECO | ST71LLU | ZCFCH35A805439337 | NEW | X | 1785.5 | 7995 |
