Fiscal Year-To-Date 1

[LOW]

I have created a report that uses a date range for a parameter (?DateStart and ?DateEnd).

What I am trying to do is run a fiscal year-to-date total on a field I&quot;ll call transaction_amount. If the date range month is > June, then I want the ytd to start at 7/1 and end at ?DateEnd. If the date range month <=June then I want the ytd to start at 1/1 and end at ?DateEnd.

Anyone have any ideas how to do this? Is there a function for FiscalYTD?

Linda-

 

[kenhamady]

There is no function, and it wouldn't help you since you are using two different start dates at the same time.

To calculate what you describe based on an input date you do this formula called FiscalStart:

If Month({input}) >= 6
then Date( Year({input}), 7 , 1 )
else Date( Year({input}), 1 , 1 )


Now you can use the following boolean for selecting or after an if:

{Date} in {@FiscalStart} to {?EndDate} Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[LOW]

This is great! Thank you so much.

Linda