Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel Report - Formula AVERAGE vs AVERAGEIF
-
Hi Phil,
I have included a formula AVERAGE in the excel report. I have no issue running the excel report. However when I change the formula from AVERAGE to AVERAGEIF in the excel report, I encounter error in running the excel report. Error message is "Failure: Error in evaluating cell Data!D2". Cell Data!D2 is where the formula resides.
Do you know the reason?
Thanks.
Felicia
-
Hi Felicia,
I don't entirely know the reason, but it's in the Apache POI library and not in the Mango code, as suggested in our testing upon the last ask of this: https://forum.infiniteautomation.com/topic/3386/excel-reports-function-compatability
-
The AVERAGEIF is not [yet?] a supported function of Apache POI:
