First of all i want export a csv where the endprice is the price with tax (got that fixed) or display the reduced price.
The best way would be that only one price is displayed (the normal price or when there is a reduction percentage, the reduced price.
i have been experimenting with this, but as you can see in the screenshot, i am doiing something wrong.
Secondly, i only want to export the products that have "published status=1". so not the status=0
You need to add percentage to the base price. Create custom field for expression as shown on screenshot:
Regarding this request "i only want to export the products that have "published status=1". so not the status=0"
You need to use product filter, select all products and export. Please, check screenshot: