Solved

MDX Percentage

Posted on 2013-11-12
2
209 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Access Query 4 34
MS SQL export CSV & schedule It 9 44
Oracle Subquery bad Join 11 43
PL/SQL - Leading zeros 7 41
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

706 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

17 Experts available now in Live!

Get 1:1 Help Now