Solved

MDX Percentage

Posted on 2013-11-12
2
213 Views
Last Modified: 2013-11-14
i've got the following percentage calculation, but need to format the % to 'example 4.5%'. Also account for null values.

([Measures].[Current Bed Count]/[Measures].[Current Available Bed Count])

Thanks.
0
Comment
Question by:aneilg
2 Comments
 
LVL 12

Accepted Solution

by:
Tony303 earned 365 total points
ID: 39646678
How does this go for the formatting?

([Measures].[Current Bed Count]/[Measures].[Current Available Bed Count]),
format_string = '0.00%'

How does this go for Null in the numerator and formatting?

IIF(ISEMPTY([Measures].[Current Bed Count],0)/([Measures].[Current Available Bed Count]),FORMAT_STRING = "PERCENT"
0
 

Author Closing Comment

by:aneilg
ID: 39647253
perfect thanks.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Query Lookup based on range 2 41
MS SQL export CSV & schedule It 9 53
Select2 jquery help 9 74
1 FROM DUAL wont work with additional columns ?? 4 26
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

21 Experts available now in Live!

Get 1:1 Help Now