Leading Row Formatting

DamarisE
New Contributor II

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?

 

1 ACCEPTED SOLUTION

db_pdx
Contributor III

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

View solution in original post

2 REPLIES 2

db_pdx
Contributor III

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

DamarisE
New Contributor II

This works!  Thank you so much.