You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Prior balance (Spanning in years and months)

Received Response
31
Views
7
Comments

Summary:


Content (required):

Hi

I need to do the following scenario, where i need to get the prior month balance + current month balance.

but when it spans over the next year, @prior function does not work. For Apr, even if i write separately another function to get the balance from march, other months become inaccurate as it is a moving balance.


Highlighted in cream color, is what im trying to achieve. periods and years are variable based on the date entered by the user.




Following script does not work. even if i put a LOOP to it. because once apr gets updated, other months have to. and then once other months get updated, apr have to be updated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!