Jump to content

Summarizing Calculated Values


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

Recommended Posts

I feel like I'm on quite a roll with all the help I've gotten from this forum lately, so I think I'll press my luck with another question.

I'm working on a module for my cabinetshop database that makes it easier to pass work orders to the back. It starts out at the front end with a SHOW CUSTOM DIALOG script and ends up with a series of scripted find statements.

In the middle of all this is the part where you capture elapsed time on each work order. I have introduced a summary field that totals all of the elapsed times. It works just fine as long as every work order that has been started is complete.

The problem is that if somebody has hit the START button and has not completed the work order, the summary field result is a great big question mark (?).

Is this because I have an open loop of some kind?

Is there a way to have the summary field show the total of all records except for the current, active record?

Does anybody have any thoughts on this?

Thanks,

Jarvis

Link to comment
Share on other sites

Without knowing field types and how you're calculating the time taken, I can't get too specific. But the you should be able to make a second calculation field that uses this kind of logic:

ConditionalTime = if(iscomplete,timetaken,0)

Then summarize ConditionalTime, which should only have values if the order is complete.

Jeff

Link to comment
Share on other sites

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