• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1393
  • Last Modified:

Cognos 8 percentage calculation

Hi

I am using cognos 8 i would like to divide the results of 2 columns and give the result as a percentage in a new column. Can anyone help me with this please?

Thanks

Adam
0
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
nmcdermaidCommented:
Is this based on a relational or cube data source?

Which studio is this in (Analysis, Report or Query)?

Generally speaking, you just need to drag a calculation object on to the data grid, and put the calculation expression that you want in it. You can access your other two source columns when you build the expression.
0
 
ac_davis2002Author Commented:
Thanks thats great!!

I am going to post an other question this time about using prompts and queries from the prompts if you are interested it would be great
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now