Double values in one column

[Anonymous]

Hi,

I have a matrix with multiple values, to minimize the size I would like to add measures into each other.

For example I have a measure for a MAT Value calculation and one for a MAT index calculation.

What I need is an output like this: 45.555 (110)   --> MAT value (Mat index)

Is this possible?

[Mikelytics]

@Anonymous 

Then you have to put the round function into the Index Measure. If you do not knwo how can you please show the index ,measure?

[Anonymous]

MAT index = [MAT Value]/[MAT LY Value]*100

[Mikelytics · Accepted solution]

@Anonymous  ok, then please adjust the measure like this

MAT index = ROUND([MAT Value]/[MAT LY Value]*100,0)

MAT index = 
ROUND(
   [MAT Value]/[MAT LY Value]*100
   ,0
)

and for the concat please use the first I posted

Concat Measures = 
Round([MAT Value],4) 
& " (" 
& [Mat Index] 
& ")"

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Anonymous]

Thanks!

Only struggling now with the formatting as it misses a thouasand seperator and is seen as a text. But I'll try to figure something out.

[Mikelytics]

Hi @Anonymous ,

Pleas try the following

Concat Measures = 
Round([MAT Value Measure],4) 
& " (" 
& [Mat Index Measure] 
& ")"

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Anonymous]

Just one question, as it seems to work. Normally my MAT value and index are number based on whole numbers, but now the outcome is with 10 decimals. How can I fix this as your measure seems to be limited to a text field?

[Mikelytics]

Hi @Anonymous 

you can round it with zero decimal values.

Concat Measures = 
Round([MAT Value Measure],4) 
& " (" 
& Round([Mat Index Measure],0) 
& ")"

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Anonymous]

Won't work, probably because the mat index measure is labeled as a text with the ".