Hi Eliot,
Thanks for the modification. In the settings it looks like what I want, but the result is not correct.
When I take a certain period and I do a csv export, the sum of "order_full_price" is not the same as the result in the report for the same period. The order_full_price is incl VAT and shipping and in boht situations I only look at the results with "order_status" is confirmed or shipped.
I.e. in the csv export, the total of the "order_full_price" is 135.29 and the total of "order_shipping_price" is 7.92. The result of 135.29 - 7.92 = 127.37. These results are the same in both the csv export and the report at my Hikashop.
But when I try to display the "order_full_price" at the report (incl. VAT and incl. shipping selected "Yes"), the result is in my case 148.20. That is not the correct result.
Also when I want to display the totals incl. VAT and excl. VAT, the difference must be only the VAT. But when I add the 21% VAT to the amount excl. VAT, it's not the same as the amount incl. VAT at the report.
The most important thing I need is the sum of "order_full_price" in a selected period for the "order_status"= confirmed or shipped.
I hope you can find out where the calculation is wrong.
With Kind Regards,
Remko Rijpkema