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.
Best answer by CallumW
View originalThere 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.
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.
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?)
Is there a place in IFS where you can change currency setting?
+15
In Tools/Options you have IFS Currency format
Thank you. That worked.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
