Report Portal

Problems with FORMAT_STRING, VBA functions and NON_EMPTY_BEHAVIOR

Consider the following requirement: "We want our measure to be truncated to 4 decimal places without any trailing 0s after the decimal point and a comma as a thousands separator."

First, let's focus on the truncation part. If we want that to happen for a measure, we can do it through the following formula, as I have described previously:

SCOPE([Measures].[Our Measure]);
This = Fix([Measures].[Our Measure]*10^4)/10^4;
END SCOPE;

This takes care of our truncation. So far so good.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.