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
Go To Solution
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

About Christopher A Hopkins
Questions
31
Answers
22
Best Answers
6
Best Answer
Best Answer
Answered By 65 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

About Wade S Veith
Questions
17
Answers
102
Best Answers
33

How to get msn for android tab support video call soft?

Previous

How to wrap bootable CD dvd with paper?

Next

Related Questions