NaN when editing grid values

1
Hi, I have several grids where certain columns are editable. Some of these editable fields are currency or float and will be used for calculations (through a before commit event). If the field is cleared I get automatically a NaN error and don't even have the chance to run the microflow where I could check for an empty field. I have added a "required" validation in entity, but it seems useless as never picks up anything and it just proceeds as if there is nothing wrong and meanwhile the console is being populated with exceptions. I've noticed similar error reported last year in Feb. Problem seems to still exist. Is there a solution for this? LR. com.mendix.core.CoreException: Exception occurred in action '{"type":"ChangeAction","changes":"{Balance=NaN}"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.c(SourceFile:485) Caused by: java.lang.IllegalArgumentException: Float string value should not be NaN at com.mendix.core.objectmanagement.member.MendixCurrency.getValueFromString(SourceFile:55) at com.mendix.core.objectmanagement.member.MendixCurrency.getValueFromString(SourceFile:17) at gK.a(SourceFile:305) at gK.a(SourceFile:120) at gK.executeAction(SourceFile:53) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:434) at hg.b(SourceFile:155) at com.mendix.core.Core.change(SourceFile:541) at fV.execute(SourceFile:58) at iD.a(SourceFile:306) at iD.a(SourceFile:235) at iD.processRequest(SourceFile:179) at iG.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:842) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:43) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662)
asked
1 answers
0

Do you know of it is the value itself, or the calculation causing this error? I know of other programs where NaN happens in case of undefined results like 0/0 or 0/null or 0/empty or empty/anything ...

answered