Jump to content

status fields not evaluating all related line items


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

Recommended Posts

I am making a solution for creating and tracking estimates and work orders. I would like to make a layout that shows the status of the work orders in each dept. that may be working on them. I have this set up in a list view that shows the different depts. with a calculation field for each that describes the status. This layout is based on the work order table. Each work order has a line item portal which is based on the line items table (the portal, that is). The problem I'm having is that each caculation field describes only the first line item for each work order instead of evaluating the status of every line item. If every related line item had status of "done" then I would like the calc field to indicate "done". If, however, only one of the related line items had status "done" then I would like the calc field to indicate "open". Sorry if this sounds confusing. I'm a noob and might have bitten off more than I can chew.

Edited by Guest
Link to comment
Share on other sites

In the line items table, define a calculation field cDone (result is Number) =

Status = "Done"

In the work order table, define a calculation field (result is Text) =

Case ( Count ( LineItems::ItemID ) = Sum ( LineItems::cDone ) ; "Done" ; "Open" )

Note:

ItemID is an auto-entered serial number. You can count any field that is certain to never be empty.

Link to comment
Share on other sites

Thank you very much Comment. That makes complete sense and better than than, it works! I understand the concept now and can see where this could be used in different ways.

Again thanks for the quick response.

Link to comment
Share on other sites

This topic is 5687 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
 Share

×
×
  • Create New...

Important Information

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