Cummulative total should be restarted at beginning of the year

Dear members,

I am trying to generate a report in which there are 3 columns showing balances...Daily, Monthly and Yearly

Daily balance is cash balance at the end of the day, which changes every day.
In Monthly column Balance becomes cummulative i.e. Previous Day Balance + Today's Balance and it restarts automatically on every 1st day of the month.
In Yearly column I want the balance to become cummulative i.e. it should start from 1st April and continue till 31st March and again restart automatically if financial year changes.

in the Monthly column I have created the field and Set the following formula

Set as : IF $$DayOfDate:$Date=1 THEN #DetDailyTotal ELSE #DetDailyTotal+$$PrevLine:#DetMonthTotal

and its working fine.

In yearly column I am trying but not able to get what I want.

Kindly help me in this getting the value I want.

Thanks in advance.

Sincerely

Ajay Singh

 

Please share your codes.