If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Total row in report

Started by sunny bachan prasad, 31 Jul 2015 10:36:27 AM

Previous topic - Next topic

sunny bachan prasad

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 :(

sunny bachan prasad


inu

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.

R Ambre

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