Currently, I am calculating the daily average using
=PIAdvCalcDat('Daily Data'!$C$10,'Daily Data'!$B$1,'Daily Data'!$B$2,"24h","average (time-weighted)","time-weighted",0,1,193,"au-s-alto-hist1") where C10 is the tag name, B1 is 1Jan25, B2 is the 1Feb25. This resulted in 31 rows of daily average because of Jan has 31 days.
I then times each day average by 24 if the daily average is > 2000, else make it into 0 then get the sum of daily average for the whole month. Is there a way to change my formula so that it will summarize the whole thing and just give me the total. I tried to use filter expression, but it is not working. Thank you.