Avg Bal Calc for a new fiscal year
The avg bal calc needs to take into account that the start of a fiscal year ie period 1, should only take into account Current Period Movement Balance and not include Prior period balance. Thereafter period 2, must take into account current plus movement.
Any ideas. thanks