Division by 1000 works only for the first column of the cube view

[IrinaDragusanu]

Hi dear contributors / members,

I am trying to format the Cube View cells to final value divided by 1000.

I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.

Any suggestions please?

Thanks in advance.

Kind regards,

Irina

[MikeG]

Hi @IrinaDragusanu Make sure your Cell Format is on the Cube View Properties tab.  Just a hunch, you set the format on the 1st Column definition only.  Go here: 

Hope this helps.

[IrinaDragusanu · Accepted solution]

Thank you, Mike. Just realized that I needed to divide to millions for my following columns to get the needed format. Much appreciated.