Hi Guys,
I have checked out all the threads to do with this and nothing seems to work. I have downloaded Ken Hamadys formulas and have been using them but can't get this to work. I have created formulas for fiscal year and current fiscal year. The formula for YTD works beautifully but when I use the prior year formula:
Fiscal YTD:-
if {@Fiscal Year} = {@Current Fiscal Year}
and {NMEMO.DISPATCHED} <= Currentdate
then {NMEMO.FEES}
else 0
Works great...
Prior Fiscal YTD
if {@Fiscal Year} = {@Current Fiscal Year}-1
and {NMEMO.DISPATCHED} <= DateAdd ('yyyy' ,-1,CurrentDate)
then {NMEMO.FEES}
else 0
I get a 0 result.
I am using Crystal XI and an Oracle Database..
Any help would be greatly appreciated. I am not an experienced user but have been at this for 2 days now and its soooooo frustrating..Especially as I know someone there will see the mistake straight away ( I hope)
Thanks
Mr Tanner
I have checked out all the threads to do with this and nothing seems to work. I have downloaded Ken Hamadys formulas and have been using them but can't get this to work. I have created formulas for fiscal year and current fiscal year. The formula for YTD works beautifully but when I use the prior year formula:
Fiscal YTD:-
if {@Fiscal Year} = {@Current Fiscal Year}
and {NMEMO.DISPATCHED} <= Currentdate
then {NMEMO.FEES}
else 0
Works great...
Prior Fiscal YTD
if {@Fiscal Year} = {@Current Fiscal Year}-1
and {NMEMO.DISPATCHED} <= DateAdd ('yyyy' ,-1,CurrentDate)
then {NMEMO.FEES}
else 0
I get a 0 result.
I am using Crystal XI and an Oracle Database..
Any help would be greatly appreciated. I am not an experienced user but have been at this for 2 days now and its soooooo frustrating..Especially as I know someone there will see the mistake straight away ( I hope)
Thanks
Mr Tanner