Logo
My activities
Submit a Ticket >

Toll Free: 1.877.776.2995

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))

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