Work report - cash card mixed payment not showing correctly

Screenshot 2021-11-26 at 10.25.44
ticket is showing correctly on cash card mixed payment
Cash 20.00
Card 1.00

on work report it is showing duplicated tickets on the total amount,
but not the mixed amount
Cash 21.00
Card 21.00

How to fix?

Think there is something not right in your expressions, can you paste your report script here?

1 Like

thank you for pointing me to the right direction

It is my SQL script issue, I have updated it now.

1 Like