Is there a way to create a cumulative effective ta...
# general
l
Is there a way to create a cumulative effective tax rate saved search? Column A is period, column B is cumulative profit before tax, column C is cumulative tax, column D is cumulative tax rate. I don't think Prolecto's formula will work because I'm getting an error when I use a Summary Type (because I should to group the transactions per period). Alternatively, I'm looking for a way to be able to hard code the formula like first row is January, so I can have CASE WHEN period is '01' THEN.... I think I saw somewhere that it's possible I just couldn't recall.