03-16-2023 06:17 PM - last edited on 05-23-2023 04:39 AM by JackLacava
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?
Solved! Go to Solution.
03-16-2023 07:02 PM
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
03-16-2023 07:02 PM
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
03-17-2023 09:49 AM
This works! Thank you so much.