I have a bar graph with currency as the data points but it keeps coming up with 5 decimal places for the formatt. Is there a way to make it have 0 decimal places. I have the column in the data element set to currency already.
Solved
reduce 5 decimal places to 0 decimal places in lobby element
There should be a rounding option in the element designer(pretty far down) or you could use round(column,0) in your data source.
I have tried both of your suggestions, it still looks like this.
Do you have any other suggestions? I have also tried to_char(round(total_amount),0),’L999,999,999,999’) but the lobby element wont work that way.
wcocom wrote:
I have tried both of your suggestions, it still looks like this.
Do you have any other suggestions? I have also tried to_char(round(total_amount),0),’L999,999,999,999’) but the lobby element wont work that way.
What does your data source look like? What if you just set the column to currency?
When i set the column to currency is when i get the 5 decimal places added. This is how it is set.
wcocom wrote:
When i set the column to currency is when i get the 5 decimal places added. This is how it is set.
This is what I’m getting with currency:
| Column | Alias | Type |
|---|---|---|
| to_char(date_entered,'MM-WW') | MonthWeek | Text |
| sum(&AO.customer_order_api.get_total_base_price(ORDER_No)) | Base Price | Currency |
If I instead just set the base price to Number instead of currency, I get (what I think you are looking for?)
+15In Tools/Options you have IFS Currency format
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.