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.
Tags: mdx