Get an error in pentaho report designer

Asked By Karen G Bedard 0 points N/A Posted on - 03/23/2013

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.

• Status: Open
• Question Views: 942
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MultiMedia Applications

Best Answer by Wade S Veith

Go To Solution

Answered By Christopher A Hopkins 40 points N/A #134749

Get an error in pentaho report designer

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

• Vote Up 0 Vote Down

• Posted on - 04/19/2013
• Question Category: MultiMedia Applications

Best Answer

Best Answer

Answered By Wade S Veith 65 points N/A #134750

Get an error in pentaho report designer

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

• Vote Up 0 Vote Down

• Posted on - 05/05/2013
• Question Category: MultiMedia Applications