Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Filte with Actual Dates

2 replies [Last post]
Thu, 2008-07-31 15:41
Ad Ben
User offline. Last seen 16 years 31 weeks ago. Offline
Joined: 31 Jul 2008
Posts: 4
Groups: None
Ok, In P3 I have my submittal’s made up for sorting with "Sub" in Area, and the Engineer’s review with the same area and also "Eng" in Item.
For my fabrication, I have "Fab" in area.

What I want to do is make a filter that basically gets me this.
When Item contains "Fab" & if the predecessor to that "Fab" has an actual finish, show both.

How do I do that???
Top

Replies

Mon, 2008-08-04 08:52
#1
Ad Ben
User offline. Last seen 16 years 31 weeks ago. Offline
Joined: 31 Jul 2008
Posts: 4
Groups: None
Well I don’t totally understand what your saying, I tried what I thought you were saying, and all I got was "FAB" that was 100% complete.

Let me try this again.
In the Activity codes. I have my engineers submittal review listed in "Item" as "ENG".
In "Area" I have my fab listed as "FAB".

From what you wrote I made a filter that is level 1
Area/ Dept = FAB
Item = ENG
Level 2
percent complete = 100%

What I get is all Eng. Submittals and Fab that are 100%.
What I want is Eng. Submittals that are 100% and any Fab that is not 100%

Does that make sense?
Thanks for your help!!
Top
Sun, 2008-08-03 04:05
#2
Muhammad Zeeshan ...
User offline. Last seen 30 weeks 1 day ago. Offline
Joined: 12 Mar 2008
Posts: 45
Groups: None
Well i guess what you can do is to Filter Activity
Level 1
Activity Id EQ FAB
Activity des FAB/ENG

Level 2
Percent comp 100
Top