Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Max Health Value based on Main Project

Hello   I can't find a working solution for my problem.   I have a table named ht_ProjectData with Projects and Phases. I want a additional column for the "Project Health". It should show the hi...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    I believe:

     

     

    MainProjectHealth Column =
  IF(
    [ProjectType] = "Project",
    MAXX(
      FILTER(
        'Table',
        [MainProject] = EARLIER([MainProject]) &&
        [ProjectType] = "Phase"
      ),
      [Health]
    ),
    BLANK()
  )

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I believe:

 

 

MainProjectHealth Column =
  IF(
    [ProjectType] = "Project",
    MAXX(
      FILTER(
        'Table',
        [MainProject] = EARLIER([MainProject]) &&
        [ProjectType] = "Phase"
      ),
      [Health]
    ),
    BLANK()
  )