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
2 years ago

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.