Excel Report - Formula AVERAGE vs AVERAGEIF
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?
phildunlap last edited by phildunlap
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
phildunlap last edited by
The AVERAGEIF is not [yet?] a supported function of Apache POI: