In this release:
- Reporting: Filters for readers. Set Filters for readers on a Table View, and everyone who views the page gets a search box, column filters and sorting by a click on a column header, with an "X of Y rows" counter and Reset. Footer totals follow the visible rows; nothing is saved.
- Math, Conditions and Reporting: IFERROR and IFNA: IFERROR(value; value_if_error) returns the second value when the first one fails – division by zero, a lookup that finds nothing, NaN – and IFNA replaces only the "not found" of XLOOKUP, XMATCH, MATCH and LOOKUP, as Excel’s #N/A. Example: IFERROR(XLOOKUP(A2; Table1.A2:A9; Table1.C2:C9); "-").
- Conditions, Math and Reporting: "today" in date conditions and TODAY() / NOW() use the time zone of the person viewing the page, not UTC, so they no longer shift by a day around midnight.
- Reporting: JSON numbers with "," as the decimal symbol were read wrongly: 12000.5 was shown as -120.005,00. They keep their value now.
- Math, Conditions and Reporting: formulas with arithmetic before a comparison, such as A2 - B2 >= 0 or x * 2 > 10, failed with "Specified priority is not defined". They work now.
- Available now in Confluence Cloud; no action needed. Reporting for Confluence Cloud is version 2.9.0.