Common Formulas of Hierarchical Coordinates-FineReport Help Document

Last update：December 13, 2024

Overview

Common formulas of hierarchical coordinates are generally used to write conditional expressions for data filtering.

For the specific application of the common formulas of hierarchical coordinates, you can see the following sample figures and practical examples.

Expression	Description	Application
Cellx[!0]	Returns all the values expanded from cell x.	Proportion Note: You are advised to calculate the proportion by the PROPORTION function in FineReport 11.0.4 and later versions.
Cellx[!0]{Conditional expression}	Filters part of the data expanded from cell x through a conditional expression.	Conditional Summary Note: You are advised to calculate the cumulative value by the ACCSUM function in FineReport 11.0.4 and later versions.
&Cellx	Returns the position of each data expanded from cell x.	MoM Note: You are advised to calculate the comparison with the previous period by the MOM function in FineReport 11.0.4 and later versions.
$Cellx	Returns the values corresponding to each position expanded from cell x.	Conditional Summary

中文（简体）中文（繁體）日本語

English