I have a measure which would turn out to be a percentage of negative values e.g. -40%. The value_format I put in is "#.0000;(#.0000)" so I expect it would show up as -0.4000 and I can reformat it in the Visualization. But instead, it appears as 0 so I wondered maybe it got rounded up? I checked the two dimensions that this measure is based on - they have correct numbers. So it is not a matter of incorrect calculation but rather a wrong formatting.
I also have another measure which would show up as something like 169% but it returned as 200% and the format is decimal_2. I set it as decimal_2 so I thought it would populate as 168.57.
So my question is -
What is the value_format input of
Thanks!