KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to get sum of one column to use it in calculatedColumn process #969

Closed Eugene opened this topic on on Jul 4, 2019 - 2 comments

Eugene commented on Jul 4, 2019

Hi,

My question is in the subj :-)

I need to add a calculated column to my table. But in calculation i need to use a sum of all values from the other column. I know how to get it using group process but i don't need the grouped table. So i see the following solution - split my flow and in 1st subflow get the sum value using the group process and then in the 2d subflow I can use this value in the calculated column process.

It looks a bit complicated so may be there is a easier way?

KoolReport commented on Jul 5, 2019

You may use the AggregatedColumn to create sum column and then you use CalculatedColumn after that.

Eugene commented on Jul 5, 2019

Thanks

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
solved

None