Thu, 24 Sep 2026
Login

Error formatting currency column in data list

Confluence User - 08 Sep, 2022

Hi guys

i'm trying to format currency column in data list with bean shell script with the following code:


	   String texto = String.format("%,.2f", value);

the joget platform returns the error message below:


``String texto = String.format("%,.2f", value); return "<span style=\"color:green . . . '' : Typed variable declaration : Error in method invocation: Static method format( java.lang.String, java.lang.String ) not found in class'java.lang.String'


obs: this code is running ok on eclipse IDE.


thanks,

Paulo Nascimento

datalists

4

Confluence User •
08 Sep, 2022 •
confluenceUser •
•
confluenceUser •

String texto = String.format("%.2f", value);

Remove the comma and try again

Confluence User •
09 Sep, 2022 •
confluenceUser •
•
confluenceUser •

Hi Mohamed,

thanks to asnwer my question.

After remove a comma the collumn data has a blank values.


Another error to render in another date time type collumn:

"ERROR 08 Sep 2022 21:21:52 Date Formatter - jwc_paulomnasc : java.text.ParseException: Unparseable date: "2022-09-13" 5303 java.text.ParseException: Unparseable date: "2022-09-13"


Collun configuration in Date formatter: (on Brazil dd/mm/yyyy is a large used date format)




Confluence User •
10 Sep, 2022 •
confluenceUser •
•
confluenceUser •

Did you manually write this date? or did you select it from the date picker?

The only way i got this error is by manually writing the date in a different format than the one written in "Data Format" of date picker in form builder 

Confluence User •
12 Sep, 2022 •
confluenceUser •
•
confluenceUser •

Hy Mohamed.

You´re ok ?

I´m select from the date picker.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor
How to customize datalist process formatter
Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.
Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.
I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?
I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?
List Question
Create Folder on the Home Page
Async search list with ajax
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print