How do I write a percentage formula in BO
Posted on 2011-02-11
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?