Eclipse Community Forums: BIRT » Neon Expression Builder

Home » Archived » BIRT » Neon Expression Builder - IF statement Syntax(how to format an if condition in BIRT chart expression builder)

Show: Today's Messages :: Show Polls :: Message Navigator

Neon Expression Builder - IF statement Syntax [message #1840247]

Fri, 09 April 2021 15:31

david moran

Messages: 3
Registered: April 2020

Junior Member

Good morning,

in my source data i have several variables that are time duration values (in seconds). when combining these attributes in a BIRT bar chart,
using the expression builder, to get an average value from the raw 'seconds'
for example, i have this:

BirtMath.round(row["RPT1B2BTIME"]/(row["RPT1CONNCOUNT"]*60),1)

Yields an average value in minutes.
issue is if the "Rpt1ConnCount" is zero,
i have a divide by zero condition, which seriously messes up my graph.

i want to to set the condition something like this:

IF row["RPT1CONNCOUNT"] > 0
BirtMath.round(row["RPT1B2BTIME"]/(row["RPT1CONNCOUNT"]*60),1)

is it possible to do this in the expression builder?
if yes, do you have a syntax example i could follow?

Thanks,
David

Report message to a moderator