BIRT Conditional aggregate in an expression

mxenakis · 2014-09-17T17:59:20+00:00

Hi - I'm new to BIRT and I'm trying to build an aggrigate based on a condition. I've got the following Fields: PLAN1 PLAN1_VALUE PLAN2 PLAN2_VALUE PLAN3 PLAN3_VALUE I need to write a…

mxenakis

Hi -
 
I'm new to BIRT and I'm trying to build an aggrigate based on a condition. I've got the following Fields:
 
PLAN1
PLAN1_VALUE
PLAN2
PLAN2_VALUE
PLAN3
PLAN3_VALUE
 
I need to write a condition as follows:
 
If PLAN1 = 'SALES' then PLAN1_VALUE ELSE 0 END IF;
+
If PLAN2 = 'SALES' then PLAN2_VALUE ELSE 0 END IF;
+
If PLAN3 = 'SALES' then PLAN3_VALUE ELSE 0 END IF;
+
If PLAN4 = 'SALES' then PLAN4_VALUE ELSE 0 END IF;
 
I'm getting an error when trying to write the expression. I'm new to javascript

I can get the one condition to work, but I'm running into a problem with adding them together.
 
if (dataSetRow["PLAN1"] = 'Sales' ){
dataSetRow["PLAN1_VALUE"];
}
else {
0;
}
+
if (dataSetRow["PLAN12] = 'Sales' ){
dataSetRow["PLAN2_VALUE"];
}
else {
0;
}
 
You're help would be greatly appreciated!
+
if (dataSetRow["PLAN3"] = 'Sales' ){
dataSetRow["PLAN3_VALUE"];
}
else {
0;
}

Find more posts tagged with

Comments

jverly01

If you copied/pasted your javascript, there's an error in your PLAN2 section:
<pre class="_prettyXprint">
if (dataSetRow["PLAN12] = 'Sales' ){
</pre>
I'm guessing you wanted that to say:
<pre class="_prettyXprint _lang-">
if (dataSetRow["PLAN2] = 'Sales' ){
</pre>