developers

    Forum Stats

  • 3,873,649 Users
  • 2,266,621 Discussions
  • 7,911,596 Comments

Discussions

Getting -INF as a column value in bi Publisher report output

Hitesh Saroha
Hitesh Saroha Member Posts: 13 Blue Ribbon

Hi All,

I am using below tag to calculate a field vale. Sample tag is mentioned below.

<?(sum(current-group()/GROSS_PROFIT) div sum(current-group()/ORDER_VALUE))*100?>

value for sum(current-group()/GROSS_PROFIT) is  -0.00

value for sum(current-group()/ORDER_VALUE) is 0.00

But when these values are divided we are getting -INF printed in report output for this field value. See attachment .

We do not need to display this -INF instead 0 can be used , please suggest how to handle this.

Thanks,

Hitesh


Tagged:

Answers

developers