The SAS Output Delivery System and reporting techniques

Formatting Using SQL/JDBC in BI Dashboards

Reply
Contributor
Posts: 50

Formatting Using SQL/JDBC in BI Dashboards

Does anybody know how to format data in the SQL/JDBC statement to show percentages?? The format of the data is defined as percent12.2 but when querying it returns the decimal value.

Ex Code:
select name, value from dboard.financial_metrics_ytd where metric = 'Gross Margin Ratio' and scope = 'Company'

I'm trying to do something to force the value column to show as a percentage. Some of the indicators will format for you, but some do not.
Ask a Question
Discussion stats
  • 0 replies
  • 90 views
  • 0 likes
  • 1 in conversation