Skip to main content
OneStream Employee
Oct 16, 2023 8:49 PM UTC
Solved

Formatting for different member expansions

I have a report that has a specific formatting request. The report uses two Member Expansions in the columns. The client requests that the 1st member expansion have no formatting, but the 2nd member expansion be in bold. Is it possible to apply different formatting to each member expansion? 

E.g Member expansion 1 is U1#Top. Member expansion 2 is the S#Actual. Client requests U1#Top be in plain text, while S#Actual be in bold.

 

Thank you

matt515Answer
Newcomer
Oct 16, 2023 9:46 PM UTC

In the header format try this conditional statement:

If (ExpansionLevel > 1) Then Bold = True Else Bold = False

I had Time in Expansion Level 1 and Scenario in Level 2 and this bolded Scenario and not Time. Not sure if that's what you're looking for. 

ConditionalFormatting.png

1 reply

matt515Answer
Newcomer
Oct 16, 2023 9:46 PM UTC

In the header format try this conditional statement:

If (ExpansionLevel > 1) Then Bold = True Else Bold = False

I had Time in Expansion Level 1 and Scenario in Level 2 and this bolded Scenario and not Time. Not sure if that's what you're looking for. 

ConditionalFormatting.png