The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Fuad95's avatar
Fuad95
New Contributor
3 years ago

Adding % to Cube View Column

In the below screenshot, I want to add % (beside the numbers) to the utilization % but whenever I try to add % using cube view formatting, it adds % to all of the four columns. Is there any specific way I can just add % to just utilization %.

Note: CM and YTD are two columns. Hours and Utilization are levels which fall under these two columns (CM & YTD)

 

4 Replies

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    Try this conditional format

    If (ColE2HeaderDisplayText = 'Utilization %') Then
    ShowPercentSign = True
End If

     

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    Fuad95  can you show us where you add the formating? And the columns of your cube view in your designer?

    • Krishna's avatar
      Krishna
      Valued Contributor
      3 years ago

      This should be in your Cell Formatting.

  • sahilp's avatar
    sahilp
    New Contributor II
    3 years ago

    I would suggest breaking the expansion so that you have 4 columns to apply individual column formatting. That's probably the easiest method. You could achieve it with conditional formatting as mentioned previously.