Skip to main content
D
DamarisE
Newcomer
March 16, 2023
Solved

Leading Row Formatting

  • March 16, 2023
  • 1 reply
  • 0 views

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?

 

Best answer by db_pdx

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

1 reply

D
db_pdxAnswer
Contributor
March 16, 2023

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

    D
    DamarisEAuthor
    Newcomer
    March 17, 2023

    This works!  Thank you so much.

    Terms & ConditionsAccessibility statement