Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago

Cube View NumberFormat for millions

Hello,

Is there a way to make cells display numerical data in the millions of dollars amount? As an example 1,500,000 would be displayed as 1.5

I have looked around but did not find much information on the NumberFormat paramater so it is kind of confusing in terms of synthax.

Thank you in advance for your time and participation.

Cube View
  • Leasa's avatar
    Leasa
    3 years ago

    Hi, then you can try the conditional formatting.

    For example, you can choose to only apply the scale to the rows without "percentage" in the row names using the below: 

    If (RowName DoesNotContain 'percentage') Then
    Scale = 6, NumberFormat = N1

    End If

    • FM's avatar
      FM
      New Contributor III
      3 years ago

      aricgresko, I appreciate your post but it seems more involved than I was hoping for. I would expect that changing number formatting should be easier than that.

    • ChristianW's avatar
      ChristianW
      Valued Contributor
      3 years ago

      Hi aricgresco

      This is very helpful, if you want to make different versions of scaling available for everybody, but maybe too much if you only need it for a report.

  • aricgresko's avatar
    aricgresko
    Contributor III
    3 years ago

    For a single report, yes my suggestion would be more involved than needed and Christian's suggestion is the way to go.  I'm assuming you would want to drive consistency among all reports, so a good way to do that is to leverage the UD8 scaling idea.  Either way, I think you have a few good options!

  • ChristianW's avatar
    ChristianW
    Valued Contributor
    3 years ago

    It is the excel syntax for number formats.

    Is there a reason, not to use the scale option? 

    • FM's avatar
      FM
      New Contributor III
      3 years ago

      Hello,

      No there is no reason not to use the scale option. Do you think that it is better suited?

      • ChristianW's avatar
        ChristianW
        Valued Contributor
        3 years ago

        Yes, if you set it to 6 and then use number format N1 or N2, then you should get what you are looking for. 

        If you want to use format, you can try #,, #.0,, or #.00,,

        If you google excel custom format, you will get plenty of results explaining the concepts behind it.