PWA View - Custom Filter

[ST]

Is it possible to create a filters for a PWA Project Detail view such that:

[Finish] is greater than [Deadline] AND
[Deadline] is not equal to "NA"

When I try to validate, I get an error message that I am not using a correct
date format in the value box.

 

[Jonathan Sofer [MVP]]

Unfortunately, PS2007 filters in PWA were limited to validated entry values
only. This limits your abilities to do filters like that on the fly because
"NA" is not a valid date value. It is actually stored in the DB as a large
number greater than 55000 and visually translated to NA in PWA and Project
Professional. But you can use the number either because a number is not a
valid date value either.

I think the only workaround is to create a custom enterprise formula field
that returns a single text value, number value, or true or false value for
the condition you are looking for below. Then you can use that field to
filter on in the project details.

The drawback being you are forcing more calculated fields on the server
which can slow down performance if you have large schedules and lots of
other custom fields. Also, each schedule will need to be opened,
re-calculated and re-published for this new field to calculate.

Hope this helps,

Jonathan