PAW Drill Process query - Formatting numbers
Hi everyone!
I created a Drill Down process in PAW using an Oracle SQL query for fetching some detailed data for a call.
This works fine, and PAW automatically displays my DB records with the column headings as defined in the query.
The only thing is that numbers are not displayed correctly.
1. the numbers are left-aligned, not decimal
2. the decimal point is displayed as a dot "." but should be a comma "," for my region
Is there a way to display formatted numbers in PAW from the query?
In our region, the formated numbers should look like this example: 208.530,27
The DB returns 28530.27 and as said, paw displays the numbers also left-aligned, as is.
This image shows an example.
------------------------------
Asgeir Thorgeirsson
------------------------------
#PlanningAnalyticswithWatson