We have a requirement to make all the negative value to encode in parenthesis () and to display percentage % for the column "Variance vs Prior year %" in the Cube View. Anyhow, we have written formatting condition as
"If (ColName Contains '%') Then
ReportNoDataNumberFormat = [#,###,0.00;(#,###,0.00);0.00], ShowPercentSign = True
End If"
and it works perfectly fine in the data explorer tab. But while running it in the report it displays only parenthesis () and the percentage sign is missing.
The above is the screenshot from data explorer tab.
The above is the screenshot from while running it in the report.
Hi,
Go to the Cell format for the column you want to have percent sign. Then scroll down to the formatting for the Report, change ReportUseNumericBinding to True and set ReportNumbericBindingFormat to percent sign. See print screen belw.
Hi,
Go to the Cell format for the column you want to have percent sign. Then scroll down to the formatting for the Report, change ReportUseNumericBinding to True and set ReportNumbericBindingFormat to percent sign. See print screen belw.
