My activities

Compare Fiscal Year in Custom Reports

For the coordinate value, you will need to add a condition to identify the start/end of the fiscal year.  To compare fiscal year as opposed to calendar year, use the following formula:  

Cond(Month(<DATE FIELD>) < X, Str$(Year(<DATE FIELD>)-1) + “/” + Str$(Year(<DATE FIELD>)), Str$(Year(<DATE FIELD>)) + “/” + Str$(Year(<DATE FIELD>)+1))

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk