How to apply arithmetic function & show in Canned Reports

Adhoc
, , , ,
#1

Hello,

We are using open source BI Helical Insight 6.2.0.952 GA. In one of the field we would like to apply some arithmetic function and the output then we would like to show.

Like divide a numeric field value by 100 directly in Helical Insight Canned Reports?

We observed that normal division sometimes displays only integer values and removes decimal precision.

For example:

5555 / 100 = 55

Instead of:

55.55

How can we preserve decimal precision while dividing field values?

Thanks,
Snow.

#2

Hello Snow,

You can use BigDecimal.divide() in the Typography/Expression section to perform precise decimal calculations.

image

Sample Expression

$F{salary}.divide(BigDecimal.valueOf(100))

This divides the salary field value by 100 while preserving decimal precision.

Thank You,
Helical Insight.