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 for the first column.

Any suggestions please?

 

 

 

 

Thanks in advance.

Kind regards,

Irina

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.