Math Question

Please disregard my previous post because I tried to include the "Calculate the Average" script with the "Write data to a file" script which caused some type of conflict. When I created a separate script to calculate the average of VALUE_A and VALUE_B it worked fine. Thanks!!!

I'm having a problem with a session.setVariable. It appears there is a conflict when I apply the session.setVariable VALUE_CD_AVERAGE to the calculation average of VALUE_A, VALUE_B, and VALUE_CD_AVERAGE. I'm calculating the average VALUE_C and VALUE_D and saving it as a VALUE_CD_AVERAGE. This parts works fine, the code is as follows:


//Calculate the average of VALUE_CD
dataSet = new DataSet();

myDataRecord = new DataRecord();

if (session.getVariable("VALUE_C") != null && session.getVariable("VALUE_C") != "")
{
myDataRecord.put("VALUE_C",session.getVariable("VALUE_C"));
}
if (session.getVariable("VALUE_D") != null && session.getVariable("VALUE_D") != "")
{
myDataRecord.put("VALUE_D",session.getVariable("VALUE_D"));
}

dataSet.addDataRecord( myDataRecord );

session.log("how many fields in myDataRecord? " + myDataRecord.size());

int totalValues = 0;

for (int i=0; i {
dr = dataSet.getDataRecord(i);

enumeration = dr.keys();

while (enumeration.hasMoreElements())
{
key = enumeration.nextElement();
value = dr.get(key);

session.log("key:value **" + key + ":" + value + "**");
totalValues += Integer.parseInt(value).intValue();
}

session.log("Sum of all values for VALUE_CD: " + totalValues);
session.setVariable("VALUE_CD_AVERAGE",(totalValues / dr.size()));
session.log("VALUE_CD_AVERAGE**" + session.getVariable("VALUE_CD_AVERAGE") + "**");
}

Then I apply the VALUE_CD_AVERAGE to the average of VALUE_A and VALUE_B, the script is as follows:


//Calculate the average of VALUE_A, VALUE_B, VALUE_CD
dataSet = new DataSet();

myDataRecord = new DataRecord();

if (session.getVariable("VALUE_A") != null && session.getVariable("VALUE_A") != "")
{
myDataRecord.put("VALUE_A",session.getVariable("VALUE_A"));
}
if (session.getVariable("VALUE_B") != null && session.getVariable("VALUE_B") != "")
{
myDataRecord.put("VALUE_B",session.getVariable("VALUE_B"));
}
if (session.getVariable("VALUE_CD_AVERAGE") != null && session.getVariable("VALUE_CD_AVERAGE") != "")
{
myDataRecord.put("VALUE_CD_AVERAGE",session.getVariable("VALUE_CD_AVERAGE"));
}

dataSet.addDataRecord( myDataRecord );

session.log("how many fields in myDataRecord? " + myDataRecord.size());

int totalValues = 0;

for (int i=0; i {
dr = dataSet.getDataRecord(i);

enumeration = dr.keys();

while (enumeration.hasMoreElements())
{
key = enumeration.nextElement();
value = dr.get(key);

session.log("key:value **" + key + ":" + value + "**");
totalValues += Integer.parseInt(value).intValue();
}

session.log("Sum of all values for this dataRecord: " + totalValues);
session.log("Average of the sum of all values: " + (totalValues / dr.size()));
}

It appears the session.getVariable("VALUE_CD_AVERAGE") conflicts with "Static method parseInt( java.lang.Integer )" of the script because I receive the following error in the log:

The error message was: Error in method invocation: Static method parseInt( java.lang.Integer ) not found in class'java.lang.Integer' : at Line: 69.

Line 69 is:

totalValues += Integer.parseInt(value).intValue();


What do you think the conflict is? If there is additional information you need please let me know. Thanks!!!

just on a little tangent. Be careful when averaging integers. I got bitten by this recently. Integer division is just that, it returns an integer even if the result is a fraction.


int a = 1
int b = 2;
session.log("avg of a and b: " + ((a+b)/2));

this will return :
avg of a and b: 1

If the two division terms are integers it will return an integer by rounding of the result. To get a float output at least one of the division terms must be a float. i.e.:


float a = 1;
int b = 2;
session.log("avg of a and b: " + ((a+b)/2));

returns:
avg of a and b: 1.5

a neat way around this if you really want a and b to be int is to make sure the divisor is a float. Just add a decimal point:


int a = 1;
int b = 2;
session.log("avg of a and b: " + ((a+b)/2.0));

returns:
avg of a and b: 1.5