Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Calculations between rows in crosstab RRDI?

Questions
Tags
Users
Badges
Cesar Sasaki
(511●2●89●129) Feb 17 '16, 5:51 p.m.
Hi I have a crosstab and I want to make some calculations between the Rows: Crosstab

For example I want to calculate ["01 Planificado Total" / "02 Ejecutado Total"]. Also [Error/"02 Ejecutado Total"]  , etc.
Those values will be new rows below.

How can I do this on RRDI Report Studio

0 votes

2 answers
1,882 views
0 votes

2 answers

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Feb 18 '16, 4:42 a.m.
Hello Cesar,

you can try to see if you can adapt the approach described in this article to your use case:

Complex Crosstab Calculations
http://www.ibmpressbooks.com/articles/article.asp?p=1761785&seqNum=3

Best Regards,

Francesco Chiossi

0 votes

Comments
Cesar Sasaki
Feb 18 '16, 9:50 a.m.

Hi Francesco
I took a look at the link you sent, it seems that the example on the article does calculations between columns. What I need is between Rows values. "Error/Total Ejecutado" things like that.Do you know if this is possible?

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Feb 18 '16, 10:30 a.m.
Hello Cesar,

maybe you can try this:

Create a crosstab report that calculates the difference between two rows
http://www-01.ibm.com/support/docview.wss?uid=swg21339373

Best Regards,

Francesco Chiossi

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020

Question asked: Feb 17 '16, 5:51 p.m.

Question was seen: 1,882 times

Last updated: Feb 18 '16, 10:30 a.m.

Confirmation Cancel Confirm