Adding two data elements

[birk]

Hello,

 

I want to add two fields like x and Y. What I did is using expresion as follows

 

$P{DataElement:Third Antenatal Visit}+$P{DataElement:Second Antenatal Visit}

 

But this gives me just the value of each data elemen together like 12 if the value of data element1 is 1 and if the value of dataelement2 is 2.

 

 

How can I Add two values of data element

[csbac]

Hi!

The fields you are adding are string fields.

To add the numeric value, you need to convert them to integers first, by using Java means.

 

The best way would be to make sure the fields themselves are integers in the database, and are thus assigned to Integer objects.

In the case of parameters, set their type to java.lang.Integer.

 

Then, using

$P{field1}+$P{field2}

should give a class cast exception, as the result is a Integer, and is cast to a String for printing;

using

""+($P{field1}+$P{field})

should print the summed value.

 

If you cannot make the fields into Integer, you have to convert them before adding ...

""+(Integer.parseInt($P{field1})+Integer.parseInt($P{field2}))

 

Sebastian