Skip to main content
Newcomer
Mar 16, 2023 10:17 PM UTC
Solved

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 also has row supression on which means the row can and will change depending on the account, time and entity.

Has any one encountered this before?

 

db_pdxAnswer
Contributor
Mar 16, 2023 11:02 PM UTC

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

2 replies

db_pdxAnswer
Contributor
Mar 16, 2023 11:02 PM UTC

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

DamarisEAuthor
Newcomer
Mar 17, 2023 1:49 PM UTC

This works!  Thank you so much.