Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Previous entry result to be calculated


This topic is 7859 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a TOTAL figure field (totals) and a (Difference) field, trouble is i want the (Difference) figure to be CALCULATED from the PREVIOUS entry of the (totals) field.

E.G

Last months RECORD (March) the Balance was $625, this month (April) it is $500.

THEREFORE i want a CALCULATION that will pick up the PREVIOUS months (totals) figure of $625 and SUBTRACT the current (next) figure of $500, and place the RESULT of -$125 (in this case) AUTOMATICALLY in the (Difference) field.

I tried a SCRIPT to get this to work, but NO Good either.

Any help will be appreciated.

Corey...

Link to comment
Share on other sites

This topic is 7859 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.