Total Tax rates from invoices using saved search (Line total)

The Total tax rates from invoices or sales orders can be calculated using the formula:

Total tax rate:

ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 1’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 2’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘Local’ THEN {taxitem.rate} ELSE NULL END),4) 

State tax rate 

ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘Local’ THEN {taxitem.rate} ELSE NULL END),4) 

District Tax rate 

ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 1’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 2’ THEN {taxitem.rate} ELSE NULL END),4)