Skip to main content
I
IrinaDragusanu
August 31, 2023
Solved

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

  • August 31, 2023
  • 1 reply
  • 0 views

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?

 

IrinaDragusanu_0-1693486973753.png

 

 

IrinaDragusanu_1-1693486973756.png

 

Thanks in advance.

Kind regards,

Irina

    Best answer by IrinaDragusanu

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

    1 reply

    M
    MikeG
    August 31, 2023

    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: 

    MikeG_0-1693488001912.png

    Hope this helps.

    I
    IrinaDragusanuAuthorAnswer
    August 31, 2023

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

    Terms & ConditionsAccessibility statement