hi there,
i'm attaching screen shots and workbook as well. I want only one timestamp for all alerts in the sheets which i"m attaching power factor alerts , MDkw Alerts, Voltage alerts and Frequency alert.(only maximum time stamp for duplicate record.) can some one help. instead of two records in capture1 screenshot which was detailed shown in inked capture i want only one record with max timestamp for each and every sheet.
i have written for MDKW
IF LOOKUP(AVG([MD kW]),0)<>LOOKUP(AVG([MD kW]),1) THEN AVG([MD kW])
END
then i have done table down after applying this.please help.
3 respuestas
See if this helps:
Or:
{FIXED [Service No],[Phase Type],[Date],[Interval Time]:MAX([Interval TimeStamp])}
