cv304
9/8/2017 - 4:13 PM

Project Level 1

If you are looking start with the phase inquiry you could add the following formula it will only show a description for the phases that are level 1, the rest will show up blank. from there you could group them

Ajera-project-level1.sql
content_copyfile_download
Select prjPhaseLevel1Description from project
where prjPhaseLevel2 is null 
and prjPhaseLevel1 is not null 
and prjKey =[Phase Key]