Print Page - Total row in report

Title: Total row in report
Post by: sunny bachan prasad on 31 Jul 2015 10:36:27 AM

Hi Guru,
I am working on relational modelling and i have oracle as database.I have to apply below formula:

(Total number of row in Report/10) and i have to take remainder from that.

I used the mod function to get the remainder but not able to get correct number of row.I have used(Count(rows for report)) to get the total number of rows.Can any body share his experience where i am going wrong?

Thanks in advance :(

Title: Re: Total row in report
Post by: sunny bachan prasad on 03 Aug 2015 04:12:14 AM

Any updates on this?
:(

Title: Re: Total row in report
Post by: inu on 03 Aug 2015 06:00:35 AM

Quote from: sunny bachan prasad on 03 Aug 2015 04:12:14 AM
Any updates on this?
:(

Check view tabular data, if you are getting here, but not at report level, then check aggregate function , make it as none.

Title: Re: Total row in report
Post by: R Ambre on 03 Aug 2015 06:01:24 AM

Hi ,
Please use below expression
mod(
(count(rows for report))
,10)

I have tried this ,In my report I have 649 rows after dividing by 10 ,reminder should be 9 and above expression is giving same answer.

If expression is not working for you then explain me with the example so that I can help you

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sunny bachan prasad on 31 Jul 2015 10:36:27 AM