Aligning values in table

[nmyre]

This is interesting, need someone smarter than I am.

I have a table that I am using a measure to format, rounding to the millions. I would like to orient the numbers to the right, so I am using the VALUE function. However, it will work for one column and not the other. Both are formating a different measure that is a CALCULATE(SUM(column)). Both are identical, but one will orient using VALUE and one will not.

AFM DIR is using the VALUE function, the Obs will not.

The one that I want to use the VALUE function with.

The one that works.

I cannot figure out why it works with one and not the other, thoughts?

=NoMy

[BlackieB]

Hi, I'm having a similar issue.  I can get the fields in 1 of 3 columns to center align but not the others.  Just wondering what I'm doing wrong.  Thanks

E

[CNENFRNL]

Hi, @nmyre 

FORMAT func converts a value to text in the specified number format; whereas VALUE func converts a text string that represents a number to a number.

[nmyre]

Yup, I understand. Is there a better way to round a number from millions to the format above? After looking on here, it said that using FORMAT was the best way, but if there is a different way then I bet that would be better.

[nmyre · Accepted solution]

What I did was take the one measure and just divided it by 1,000,000. Keeping it simple.

@CNENFRNL