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
DamarisE
3 years agoNew Contributor II
Leading Row Formatting
I am working with a client the requires the first row of each section of their reports to have a dollar sign. No other rows in the section (outside of the total) need a dollar sign. The cube view a...
- 3 years ago
Hi DamarisE: you'll want to apply cell formatting to the first row block of your cube view report. There is a conditional format check for relative row numbers that should achieve your result, even with suppression settings.
If (RelativeRowNum = 0) Then
NumberFormat = [$#,###,0.0;($#,###,0.0);$0.0]End If
db_pdx
3 years agoValued Contributor
Hi DamarisE: you'll want to apply cell formatting to the first row block of your cube view report. There is a conditional format check for relative row numbers that should achieve your result, even with suppression settings.
If (RelativeRowNum = 0) Then
NumberFormat = [$#,###,0.0;($#,###,0.0);$0.0]
End If
- DamarisE3 years agoNew Contributor II
This works! Thank you so much.