Forum Discussion

talita19ny's avatar
talita19ny
Frequent Visitor
4 years ago
Solved

Summing only first value across a specific group

Hello, 

 

I'm trying to get a total sum for fees that are paid per user card transaction. However the dataset lists all items per transaction and includes the fee on all lines. The correct calculation for this would be taking only one fee per transaction and not per line. I would then need to add all the fees for the different transactions. transaction. How could I calculate this? The image below highlights  what needs to be added. I hope this makes sense and any help is much appreciated. 

 

Thanks

 

 

2 Replies