Hello, Is anyone worked on PMT functions? I just used java action to implement following this snippet.(https://stackoverflow.com/questions/7827352/excel-pmt-function-in-java) By applying this in java code…. After applying and run the app in mendix it return the error as Am I missed anything?
You are trying to create BigDecimal objects from strings "Tier", "Financed", "Rate", and "Term". These aren't numbers so you are seeing the exception error.
To fix this, skip these lines and instead create the Double's directly from the parameters you are passing in. e.g.