Solved

How do I write a percentage formula in BO

Posted on 2011-02-11
1
2,530 Views
Last Modified: 2013-11-16
I created 3 measures to display a summary in vertical table:

Count of Complete
Count of Incomplete
Count of  Learners

The details are below the summary table. There is a section break on Cost Center.

My Percentage formula is:
=Percentage([Count of Complete (PTD)]/[Count of Learners (PTD)])

The results returned is "1" for every Cost Center.

My previous formula:  
=Count([Learner ID]) Where([Sub-Qual Status]="Complete")/Count([Learner ID])*100+"%"
worked correctly, but did not display 0% for nulls.

How do write the correct percentage formula that will display the correct percentage per cost center, display "%" and display "0" in the column, if null?
0
Comment
Question by:KnightKreepa
1 Comment
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
ID: 34878079
It's hard to say what might be wrong with the first formula.  There could be a problem with one or more of your "Count of" measures.  I'm not familiar with the Percentage function.  BO 6.5 doesn't seem to have that.  There's a Percentile function, but that's something else.

 As for the old formula, I'm not sure what nulls you're referring to, but if the problem is that Count([Learner ID]) is null (that _would_ keep the formula from producing a result), you may just need to add an IsNull test.  Maybe something like:

=If IsNull (Count([Learner ID])) then 0+"%" Else Count([Learner ID]) Where([Sub-Qual Status]="Complete")/Count([Learner ID])*100+"%"


 FWIW, you can also leave off the '+"%"' and let the formula produce a numeric result, and then format the cell as a percentage.  If you do that, you don't need to multiply the result by 100.  The percentage format will take care of that.

 James
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
display only completed quarters in SQL script 4 48
C# Crystal Reports 15 79
Crystal  - Shared vairable capture wile printing 1 36
Mask on Parameter CR2008 28 45
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now