Get an error in pentaho report designer

Asked By 0 points N/A Posted on -
qa-featured

Hello, I am using pentaho report designer. I got a problem with it. I need know how to report designer pentaho sum two columns? I tried to do it. Unfortunately it didn’t work. So experts please help me to resolve it. thanks.

SHARE
Best Answer by Wade S Veith
Answered By 40 points N/A #134749

Get an error in pentaho report designer

qa-featured

Hi Karen,

You can have the sum of two columns in the Pentaho Report Designer by going through the following steps:

a)two SUM functions and

b)one Open Formula function.
SumFunction1=SUM(column1)
SumFunction2=SUM(column2)

SumFunction3=[SumFunction1]+[SumFunction2]

For example, 

CLIENT NAME PRODUCT:A PRODUCT:B
ABC 10 20
XYZ 30 40

Total  products for Client 'ABC': 30
Total  products for Client 'XYZ': 70
Total products for all clients: 100

Best Answer
Best Answer
Answered By 60 points N/A #134750

Get an error in pentaho report designer

qa-featured

Hello,

The Pentaho Report Designer (PRD) is a desktop application that provides a visual design environment to create report definitions. The report definitions can be executed and saved locally via PRD or published to a Pentaho Bi Server to allow many people to access and schedule report execution. PRD is geared towards experienced and power users, who are familiar with the concepts and data-sources used. You can have two sum function and one formula field. It goes like these:SumFunction1=SUM(field1), SUMFunction2=SUM(field2), SumFuntion3=SumFunction1+SumFunction2

Login/Register to Answer

Related Questions