Exp

[smilingjohn]

The last run date column should show the last dae for checkin icrm as 25-06-2017 it is considering the all ...

How do i handel this ...Can someon suggeust how to write the formula for this

PLease find the attachment of the QVW file

[sunny_talwar · Accepted solution]

Try this

=Aggr(If(max(TOTAL <Almrun_masterGroup, Almrun_masterComponent> RunDate) = RunDate, RunDate),Almrun_masterGroup, Almrun_masterComponent, RunDate)