Max child value dependent on max date
I have two columns a returned date and a recorded level. The maximum recorded level is dependent on the maximum date. The value will sit in the parent row. Currently I have =MAX(CHILDREN()) in both columns. Can this be done using Children or Parent references or is an IF statement required. First time on the community so hope this is descriptive enough.