For the following query:
with
member testVal as 0.1234
member testNormal as testVal
member testPrepend as testVal, format_string="%##.00"
member testMidpend as testVal, format_string="##%.00"
member testAppend as testVal, format_string="##.00%"
select { testNormal, testPrepend, testMidpend, testAppend} on axis (0)
from [SomeRandomPlace]
The following is returned:
testNormal testPrepend testMidpend testAppend
0.1234 %.12 12%.34 12.34%
This is causing issues, as we use the same format string in .NET as a post-process operation (some control requires us to do this), and it behaves as expected (multiplying it by 100 because of the % sign).
Is this documented behaviour? Or some obscure bug? Or am I doing something wrong/weird? I feel the testPrepend member should also be multiplied by 100, but it's not.