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 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?

 

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