Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column - MAX Completion date based on 3 columns

Hi Experts

 

I am trying to work out the max completion date if all three conditions are met. See sample date 

 

I need to work out the latest work completion date Based on ID and NUM columns - the ACTDAte column must have dates against ID and NUM in order to get the MAX date.

 

As shown in our example data below we do not have a ACT date for ID 1257111 and NUM 346 - in this case new calcalated column return back blank as we have no ACT DAte for NUM 346 which is a part of ID 1257111, if we had ACT Dates then find the latest date in ACT DAte column and populate that into the new calculated column,..

 

 

 

 

Need Help

15 Replies

  • DimaMD's avatar
    DimaMD
    Solution Sage
    3 years ago

    Hi Anonymous  Is this your desired outcome?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi DimaMD the out come should be no date as we have missing entries for num  assoicated to ID - it need to be a complete set...the max if any need to be based on the 3 columns 

      • DimaMD's avatar
        DimaMD
        Solution Sage
        3 years ago

        Anonymous Can you provide your desired result?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      for each ID and Num grouping date we need to have a 1 in Date Check then return MaX date otherwise blank, as in the image above