Overview
Version
Designer Version | Functional Change |
11.0 | / |
11.0.4 | Optimization of hierarchical coordinate functions (1) Deleted the CIRCULAR function, CROSSLAYERTOTAL function, HIERARCHY function, and LAYERTOTAL function. (2) Added the ACCSUM function (substitute for the deleted CROSSLAYERTOTAL function), SUMIFS function, and COUNTIFS function. (3) Optimized the PROPORTION function, MOM function, and SORT function. |
Application Scenario
In actual scenarios, writing and maintaining hierarchical coordinate formulas is relatively complex.
To solve this problem, FineReport has made some formulas for calculating common indicators into functions, which can help improve report development efficiency.
Notes
(1) Hierarchical coordinate functions do not support simulation calculation. For details, see Result Viewing Based on the Simulation Calculation.
(2) The hierarchical coordinate function only supports cell calculations and does not support cross-sheet calculations, watermarks, JavaScript references, or default parameter values.
List of Hierarchical Coordinate Functions
Function | Description |
Supports calculating the proportion of each expanded value in expanded cells relative to the total value. | |
Supports calculating cumulative values based on different groupings. | |
Supports implementing conditional counting. | |
Supports implementing conditional summing. | |
Supports calculating rankings. | |
Supports calculating comparison with the same/previous period. |
