Forum Discussion

DamarisE's avatar
DamarisE
New Contributor II
2 years ago

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...
Cube View
  • db_pdx's avatar
    db_pdx
    2 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's avatar
db_pdx
Valued Contributor
2 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

  • DamarisE's avatar
    DamarisE
    New Contributor II
    2 years ago

    This works!  Thank you so much.