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

Need a Help on Percentage Calculations on the cross tab

Started by raja1718, 24 Mar 2011 09:00:14 AM

Previous topic - Next topic

raja1718

Hi Friends,

I am trying to calculate the Percentage values for the KPI's.

Like
                                             PROJECT1                                     
                                                   
                                             Task Completed   Not COMPLETED   Total  PerCentage(For Completed)
ManagerName
                    Employee Name   xxxxxx                xxxxxxxx             xxxx   xxxx%


Every thing is working fine Except Pecentage for Completed i am getting all the values as 100% or Zeros.

Used function in the Date item 

CurrentMeasure is "[Task no]"

I am Using the Single Data Item "[PROJECT_MET]"to count the Number of tasks "Completed" or "Not Completed" using "IF THEN ELSE" Statement.

for the Total projectwise am using the following "Total([RSLAFKPI])"
aggregate(currentMeasure within SET [PROJECT_MET])

for the Percentage projectwise am using the following "Per([RSLAFKPI])"
percentage (CurrentMeasure within set [PROJECT_MET])             

Total is perfeclty comming but the Percentage is always Zeros or 100%

Example

                                         PROJECT1                                     
                                                   
                                         Task Completed   Not COMPLETED   Total  PerCentage(For Completed)
ManagerName
              Employee Name  2                           8                          10      100 %
                                                                                                           (Should be 20% - Need
                                                                                                             for Completed tasks)


Please any one let me know the way to calculate the Completed Percentage.

Thanks in Advance !

Raj