Forum Discussion
Netope
Helper I
Helper ISite status classficiation based on different project status
Dear community: I have two tables one for site status, and the other table with project status by site where one site may have multiple projects. In the site status table I have a column for ...
1. Create a reference table
Status Status ID Not Planned 0 Not Started 1 Running 2 Closed 3 2. For each Site find the MINX of the Status ID. Add 0 if you want to cover site D.
3. Lookup the Status name for the result.
lbendlin
Super User
Super User1. Create a reference table
| Status | Status ID |
| Not Planned | 0 |
| Not Started | 1 |
| Running | 2 |
| Closed | 3 |
2. For each Site find the MINX of the Status ID. Add 0 if you want to cover site D.
3. Lookup the Status name for the result.
