src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
changeset 1688 a92f1c657ca2
parent 0 0247c26f10c6
child 1787 84217f37d788
--- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml	Fri Sep 19 16:05:40 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml	Fri Sep 19 16:19:27 2008 +0000
@@ -899,64 +899,64 @@
 		<variableExpression><![CDATA[$V{AMOUNTREF_SUM10}.subtract($V{COSTREF_SUM10})]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_1}.divide( $V{AMOUNT_SUM1}, 2, BigDecimal.ROUND_HALF_UP )]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_1}.divide( $V{AMOUNT_SUM1}, 2, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_2}.divide( $V{AMOUNT_SUM2}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_2}.divide( $V{AMOUNT_SUM2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_3}.divide( $V{AMOUNT_SUM3}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_3}.divide( $V{AMOUNT_SUM3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_4}.divide( $V{AMOUNT_SUM4}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_4}.divide( $V{AMOUNT_SUM4}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_5" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL5" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_5}.divide( $V{AMOUNT_SUM5}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_5}.divide( $V{AMOUNT_SUM5}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_6" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL6" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_6}.divide( $V{AMOUNT_SUM6}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_6}.divide( $V{AMOUNT_SUM6}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_7" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL7" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_7}.divide( $V{AMOUNT_SUM7}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_7}.divide( $V{AMOUNT_SUM7}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_8" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL8" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_8}.divide( $V{AMOUNT_SUM8}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_8}.divide( $V{AMOUNT_SUM8}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_9" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL9" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_9}.divide( $V{AMOUNT_SUM9}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT_9}.divide( $V{AMOUNT_SUM9}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGIN_10" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL10" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNT_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{PROFIT_10}.divide( $V{AMOUNT_SUM10}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNT_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{PROFIT_10}.divide( $V{AMOUNT_SUM10}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)?new BigDecimal(0.0):$V{PROFITREF_1}.divide( $V{AMOUNTREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP )]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)?new BigDecimal(0.0):$V{PROFITREF_1}.divide( $V{AMOUNTREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_2}.divide( $V{AMOUNTREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_2}.divide( $V{AMOUNTREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_3}.divide( $V{AMOUNTREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_3}.divide( $V{AMOUNTREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_4}.divide( $V{AMOUNTREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_4}.divide( $V{AMOUNTREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_5" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL5" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_5}.divide( $V{AMOUNTREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_5}.divide( $V{AMOUNTREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_6" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL6" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_6}.divide( $V{AMOUNTREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_6}.divide( $V{AMOUNTREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_7" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL7" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_7}.divide( $V{AMOUNTREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_7}.divide( $V{AMOUNTREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_8" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL8" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_8}.divide( $V{AMOUNTREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_8}.divide( $V{AMOUNTREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_9" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL9" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_9}.divide( $V{AMOUNTREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFITREF_9}.divide( $V{AMOUNTREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINREF_10" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL10" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{PROFITREF_10}.divide( $V{AMOUNTREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{PROFITREF_10}.divide( $V{AMOUNTREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="WEIGHT_SUM1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Sum">
 		<variableExpression><![CDATA[$F{WEIGHT}]]></variableExpression>
@@ -1025,67 +1025,67 @@
 		<variableExpression><![CDATA[$F{WEIGHTREF}]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM1}.subtract($V{AMOUNTREF_SUM1}).divide( $V{AMOUNTREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM1}.subtract($V{AMOUNTREF_SUM1}).divide( $V{AMOUNTREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM2}.subtract($V{AMOUNTREF_SUM2}).divide( $V{AMOUNTREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM2}.subtract($V{AMOUNTREF_SUM2}).divide( $V{AMOUNTREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM3}.subtract($V{AMOUNTREF_SUM3}).divide( $V{AMOUNTREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM3}.subtract($V{AMOUNTREF_SUM3}).divide( $V{AMOUNTREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM4}.subtract($V{AMOUNTREF_SUM4}).divide( $V{AMOUNTREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM4}.subtract($V{AMOUNTREF_SUM4}).divide( $V{AMOUNTREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER5" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL5" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM5}.subtract($V{AMOUNTREF_SUM5}).divide( $V{AMOUNTREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM5}.subtract($V{AMOUNTREF_SUM5}).divide( $V{AMOUNTREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER6" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL6" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM6}.subtract($V{AMOUNTREF_SUM6}).divide( $V{AMOUNTREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM6}.subtract($V{AMOUNTREF_SUM6}).divide( $V{AMOUNTREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER7" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL7" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM7}.subtract($V{AMOUNTREF_SUM7}).divide( $V{AMOUNTREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM7}.subtract($V{AMOUNTREF_SUM7}).divide( $V{AMOUNTREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER8" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL8" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM8}.subtract($V{AMOUNTREF_SUM8}).divide( $V{AMOUNTREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM8}.subtract($V{AMOUNTREF_SUM8}).divide( $V{AMOUNTREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER9" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL9" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM9}.subtract($V{AMOUNTREF_SUM9}).divide( $V{AMOUNTREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM9}.subtract($V{AMOUNTREF_SUM9}).divide( $V{AMOUNTREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PER10" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL10" calculation="Nothing">
-		<variableExpression><![CDATA[($V{AMOUNTREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM10}.subtract($V{AMOUNTREF_SUM10}).divide( $V{AMOUNTREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_SUM10}.subtract($V{AMOUNTREF_SUM10}).divide( $V{AMOUNTREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="AMOUNT_PERTOTAL" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
-		<variableExpression><![CDATA[($V{AMOUNTREF_TOTAL}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_TOTAL}.subtract($V{AMOUNTREF_TOTAL}).divide( $V{AMOUNTREF_TOTAL}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{AMOUNTREF_TOTAL}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT_TOTAL}.subtract($V{AMOUNTREF_TOTAL}).divide( $V{AMOUNTREF_TOTAL}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM1}.subtract($V{QTYREF_SUM1}).divide( $V{QTYREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM1}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM1}.subtract($V{QTYREF_SUM1}).divide( $V{QTYREF_SUM1}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM2}.subtract($V{QTYREF_SUM2}).divide( $V{QTYREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM2}.subtract($V{QTYREF_SUM2}).divide( $V{QTYREF_SUM2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM3}.subtract($V{QTYREF_SUM3}).divide( $V{QTYREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM3}.subtract($V{QTYREF_SUM3}).divide( $V{QTYREF_SUM3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM4}.subtract($V{QTYREF_SUM4}).divide( $V{QTYREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM4}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM4}.subtract($V{QTYREF_SUM4}).divide( $V{QTYREF_SUM4}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER5" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL5" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM5}.subtract($V{QTYREF_SUM5}).divide( $V{QTYREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM5}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM5}.subtract($V{QTYREF_SUM5}).divide( $V{QTYREF_SUM5}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER6" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL6" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM6}.subtract($V{QTYREF_SUM6}).divide( $V{QTYREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM6}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM6}.subtract($V{QTYREF_SUM6}).divide( $V{QTYREF_SUM6}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER7" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL7" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM7}.subtract($V{QTYREF_SUM7}).divide( $V{QTYREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM7}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM7}.subtract($V{QTYREF_SUM7}).divide( $V{QTYREF_SUM7}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER8" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL8" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM8}.subtract($V{QTYREF_SUM8}).divide( $V{QTYREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM8}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM8}.subtract($V{QTYREF_SUM8}).divide( $V{QTYREF_SUM8}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER9" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL9" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM9}.subtract($V{QTYREF_SUM9}).divide( $V{QTYREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM9}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM9}.subtract($V{QTYREF_SUM9}).divide( $V{QTYREF_SUM9}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="QTY_PER10" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL10" calculation="Nothing">
-		<variableExpression><![CDATA[($V{QTYREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM10}.subtract($V{QTYREF_SUM10}).divide( $V{QTYREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP)]]></variableExpression>
+		<variableExpression><![CDATA[($V{QTYREF_SUM10}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY_SUM10}.subtract($V{QTYREF_SUM10}).divide( $V{QTYREF_SUM10}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression>
 	</variable>
 	<variable name="MARGINDIFF_1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
 		<variableExpression><![CDATA[($V{MARGIN_1}!=null && $V{MARGINREF_1}!=null )?new BigDecimal(0.0):$V{MARGIN_1}.subtract( $V{MARGINREF_1})]]></variableExpression>