#AWS round double to only 2 decimal places

[jonathan_10]

Hello,

I have a time series plot in jasperstudio and the data field is type double. My y axis value is a sum over these values and I want my output to only have two decimal places.

I have tried all kinds of different data types and Math.round() caused an error after I published to Jasper server.

Here is the source code: I want $F{lowprice} to only show 2 decimal places after the sum.  thanks!

<multiAxisData>

<multiAxisDataset/>

<dataAxis axis="Rows">

<axisLevel name="Level1">

<labelExpression><![CDATA["Level Label expression"]]></labelExpression>

<axisLevelBucket class="java.sql.Date">

<bucketExpression><![CDATA[$F{arrival}]]></bucketExpression>

</axisLevelBucket>

</axisLevel>

</dataAxis>

<dataAxis axis="Columns"/>

<multiAxisMeasure name="Measure1" class="java.lang.Double" calculation="Sum">

<labelExpression><![CDATA["Total Value"]]></labelExpression>

<valueExpression><![CDATA[$F{lowprice}]]></valueExpression>

</multiAxisMeasure>

</multiAxisData>