Pentaho

 View Only

 Pentaho report designer (PRD): use functions with running sum functions

Alessandro Corradi's profile image
Alessandro Corradi posted 11-29-2021 12:05
Hi all,

I created a table in PRD like this:


First column is the current year, second is the previous.
Third is delta value created with a open formula.
The last one is delta percentage on previous year.

I used detail footer aggregation type SUM(running).

How can I combine aggregation type with delta percentage formula? Do I need to change behaviour and create a sum formula for each column?

Thank you.

Alessandro