Jump to content

Calculation fields that wait for entries


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

Recommended Posts

I have attached the file I am working on. I am looking to do a calculation for inventory purposes on yardage of fabric. There are two times we are entering in information and on the first time we enter data, we put the yardage ordered. The second time we enter data we put the yardage currently on the roll. I want a calculation that waits until I put the "starting quantity" to subtract the "yards" to get the calculated "balance remaining". Currently when I enter, say, 4 yards, it calculates -4 yards in the balance field and does not recalculate when I enter the starting quantity. Check it out and let me know.



Link to comment
Share on other sites

The calc field that you are having problems with will need an entry along these lines

Case(isempty(field1) or isempty(field2);"";whatever calculation you want to do)

Put this into the field that is giving you the -4 answer and it won't display anything if either of the fields is blank.

Make this an UNSTORED calculation and it should change as you change the data in either field.

I am sorry that I could not be more specific with my answer but your question was a little non-specific in the naming of the fields that were involved in your problem.

Might I also suggest that to get the best help possible from the forum, when you post a file for inspection you at least tell us in which of the ten files provided, the problem lies.

I am sure you will get a better response



Link to comment
Share on other sites

This topic is 5801 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.