Elastic Reports Forum Home › Forums › Understanding the Software › Elastic Reports This topic has 7 replies, 2 voices, and was last updated 6 years, 2 months ago by Mikhail. Viewing 8 posts - 1 through 8 (of 8 total) Author Posts January 2, 2018 at 8:42 am #3004 miteshParticipant Hi Mikhail, double GetMax(int timeCnl) { if (Val() > Cnl) { return Val(); } else { SetVal(timeCnl, EncodeDate(DateTime.Now)); return Cnl; } } where to use this formula. and i have gone through Elastic Reports http://doc.rapidscada.net/content/en/modules/plg-elastic-report.html January 3, 2018 at 1:51 pm #3009 MikhailModerator Hi, where to use this formula Add the formula into the Formulas table. Then use it in the Foumula field of an input channel. i have gone through Elastic Reports Do you have questions? January 22, 2018 at 4:36 am #3043 miteshParticipant Hi Mikhail, I am getting every hour data in Elastic Reports. But i just want to create Elastic Reports(Excel) in such a way that it should contain only Higher value data in a day with time. please help me to come out from this. January 23, 2018 at 11:42 am #3045 MikhailModerator Hi, Have you already created an input channel that stores max value of a day? January 30, 2018 at 9:33 am #3065 miteshParticipant Hi, Have you already created an input channel that stores max value of a day? yes, I have created an input channel that stores max value. But i want to know the time in that day for high value in Elastic reports. January 30, 2018 at 12:00 pm #3066 MikhailModerator Hi, In this case, you should create an additional input channel that stores the required time, and show this channel in a report. January 30, 2018 at 1:03 pm #3071 miteshParticipant Hi, I have Created input Channel but what formula should i use to get the required time for the higher value in a day. January 31, 2018 at 10:43 am #3075 MikhailModerator Hi, Within the formula that calculates maximum, you should save the time in the appropriate input channel using SetVal(…). To convert time to double, use EncodeDate(DateTime.Now) http://doc.rapidscada.net/content/en/software-configuration/using-formulas.html Author Posts Viewing 8 posts - 1 through 8 (of 8 total) You must be logged in to reply to this topic. Log In Username: Password: Keep me signed in Log In