Well – not exactly… so I moved Sheet 28 next to the Un Tm1 sheet – if you look at HK2144 in both sheets you will see a wrong max TS Load date in Un Tm1 Sheet.
This is the whole problem – I don’t understand why it wont work – I just want the max date – it works in Sheet 28 fine as long as I apply a calculated field with the index field with LOD.
Furthermore – the ‘Schedule Chg’ field has an asterisk – this totally makes sense because there are multiple values for each serial number in this field – but if I do it by Max Ts Load – then it should be fine – right? ☺
So frustrated!! See attached.
And thank you!
OFM Team Report In Process.twbx 14.0 MB