Hello all,
I am using Mango 2.8 with Excel Reports module 1.1.4.
Does the excel reports module support the following functions:
FLOOR
SUMIFS
AVERAGEIFS
Also if those functions are included inside IF statements?
The functions above work fine in my desktop Office Excel 2010 and are supported in our Office 365 version.
But when I run the report in the excel reports module I get an error message in the Finished Reports page saying "Failure error evaluating cell "Calculations!G5" and sometimes the cell reference changes.
Cheers
Brian