Forum Discussion

IrinaDragusanu's avatar
IrinaDragusanu
New Contributor III
2 years ago

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

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...
Cube View
  • IrinaDragusanu's avatar
    IrinaDragusanu
    2 years ago

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

MikeG's avatar
MikeG
Contributor III

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's avatar
IrinaDragusanu
New Contributor III
2 years ago

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