Forum Discussion
Format number in matrix without changing data model
Hi!
I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.
How do I format this number in my matrix without changing my data model (cause that is not helping).
Thanks!
Anonymous wrote:
Hi!
I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.
How do I format this number in my matrix without changing my data model (cause that is not helping).
Thanks!
Anonymous
You can try to format the measure by changing decimal places
7 Replies
I found where to change it:
Anonymous wrote:
Hi!
I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.
How do I format this number in my matrix without changing my data model (cause that is not helping).
Thanks!
Anonymous
You can try to format the measure by changing decimal places
I have this Same problem and the Format I am trying to change is NOT a measure, but the Summation Value of an actual Field [Value] from my query table. Despite the fact that the Field is defined as a whole number, the Value Summation in the MAtrix displays it as a a two digit Decimal Number. The paint brush formatting tab allows you to change the font, font size, color, etc. of the the Value Parameter in the Matrix, but does not list number format as an editable parameter. How can I edit the Sumation Value number format without the complication of defining a new measure, creating a new query, etc?
