calculate disc

1 files changed, 944 insertions, 7 deletions

diff --git a/calculate_price_after_disc.ktr b/calculate_price_after_disc.ktr
index 9268fa1..d1eb8f9 100644
--- a/calculate_price_after_disc.ktr
+++ b/calculate_price_after_disc.ktr
@@ -489,22 +489,32 @@
   <order>
     <hop>
       <from>Table input</from>
-      <to>Calculator</to>
+      <to>calculate price after disc</to>
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>Calculator</from>
-      <to>Calculator 2</to>
+      <from>calculate price after disc</from>
+      <to>calculate price tier</to>
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>Calculator 2</from>
+      <from>calculate price tier</from>
+      <to>calculate diff</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>calculate diff</from>
+      <to>calculate discount</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>calculate discount</from>
       <to>Insert / update</to>
       <enabled>Y</enabled>
     </hop>
   </order>
   <step>
-    <name>Calculator</name>
+    <name>calculate price after disc</name>
     <type>Calculator</type>
     <description/>
     <distribute>Y</distribute>
@@ -605,7 +615,7 @@
     </GUI>
   </step>
   <step>
-    <name>Calculator 2</name>
+    <name>calculate price tier</name>
     <type>Calculator</type>
     <description/>
     <distribute>Y</distribute>
@@ -1353,6 +1363,131 @@
         <rename>price_tier5_5</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>disc1_1</name>
+        <rename>disc1_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc1_2</name>
+        <rename>disc1_2</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc1_3</name>
+        <rename>disc1_3</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc1_4</name>
+        <rename>disc1_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc1_4</name>
+        <rename>disc1_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc1_5</name>
+        <rename>disc1_5</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc2_2</name>
+        <rename>disc2_2</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc2_3</name>
+        <rename>disc2_3</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc2_4</name>
+        <rename>disc2_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc2_5</name>
+        <rename>disc2_5</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc3_1</name>
+        <rename>disc3_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc3_2</name>
+        <rename>disc3_2</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc3_3</name>
+        <rename>disc3_3</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc3_4</name>
+        <rename>disc3_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc3_5</name>
+        <rename>disc3_5</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc4_1</name>
+        <rename>disc4_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc4_2</name>
+        <rename>disc4_2</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc4_3</name>
+        <rename>disc4_3</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc4_4</name>
+        <rename>disc4_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc4_5</name>
+        <rename>disc4_5</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc5_1</name>
+        <rename>disc5_1</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc5_2</name>
+        <rename>disc5_2</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc5_3</name>
+        <rename>disc5_3</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc5_4</name>
+        <rename>disc5_4</rename>
+        <update>N</update>
+      </value>
+      <value>
+        <name>disc5_5</name>
+        <rename>disc5_5</rename>
+        <update>N</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -1364,7 +1499,7 @@
     </remotesteps>
     <GUI>
       <xloc>736</xloc>
-      <yloc>64</yloc>
+      <yloc>192</yloc>
       <draw>Y</draw>
     </GUI>
   </step>
@@ -2253,6 +2388,808 @@ left join brand b on b.id = p.brand_id</sql>
       <draw>Y</draw>
     </GUI>
   </step>
+  <step>
+    <name>calculate diff</name>
+    <type>Calculator</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <failIfNoFile>Y</failIfNoFile>
+    <calculation>
+      <field_name>diff1_1</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_after_disc_1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff1_2</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc2</field_a>
+      <field_b>price_after_disc_2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff1_3</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc3</field_a>
+      <field_b>price_after_disc_3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff1_4</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc4</field_a>
+      <field_b>price_after_disc_4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff1_5</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc5</field_a>
+      <field_b>price_after_disc_5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff2_1</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier2_1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff2_2</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc2</field_a>
+      <field_b>price_tier2_2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff2_3</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc3</field_a>
+      <field_b>price_tier2_3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff2_4</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc4</field_a>
+      <field_b>price_tier2_4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff2_5</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc5</field_a>
+      <field_b>price_tier2_5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff3_1</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier3_1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff3_2</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc2</field_a>
+      <field_b>price_tier3_2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff3_3</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc3</field_a>
+      <field_b>price_tier3_3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff3_4</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc4</field_a>
+      <field_b>price_tier3_4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff3_5</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc5</field_a>
+      <field_b>price_tier3_5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff4_1</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier4_1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff4_2</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc2</field_a>
+      <field_b>price_tier4_2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff4_3</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc3</field_a>
+      <field_b>price_tier4_3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff4_4</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc4</field_a>
+      <field_b>price_tier4_4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff4_5</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc5</field_a>
+      <field_b>price_tier4_5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff5_1</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc1</field_a>
+      <field_b>price_tier5_1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff5_2</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc2</field_a>
+      <field_b>price_tier5_2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff5_3</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc3</field_a>
+      <field_b>price_tier5_3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff5_4</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc4</field_a>
+      <field_b>price_tier5_4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>diff5_5</field_name>
+      <calc_type>SUBTRACT</calc_type>
+      <field_a>price_before_disc5</field_a>
+      <field_b>price_tier5_5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>384</xloc>
+      <yloc>192</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
+  <step>
+    <name>calculate discount</name>
+    <type>Calculator</type>
+    <description/>
+    <distribute>Y</distribute>
+    <custom_distribution/>
+    <copies>1</copies>
+    <partitioning>
+      <method>none</method>
+      <schema_name/>
+    </partitioning>
+    <failIfNoFile>Y</failIfNoFile>
+    <calculation>
+      <field_name>disc1_1</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff1_1</field_a>
+      <field_b>price_before_disc1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc1_2</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff1_2</field_a>
+      <field_b>price_before_disc2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc1_3</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff1_3</field_a>
+      <field_b>price_before_disc3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc1_4</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff1_4</field_a>
+      <field_b>price_before_disc4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc1_5</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff1_5</field_a>
+      <field_b>price_before_disc5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc2_1</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff2_1</field_a>
+      <field_b>price_before_disc1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc2_2</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff2_2</field_a>
+      <field_b>price_before_disc2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc2_3</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff2_3</field_a>
+      <field_b>price_before_disc3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc2_4</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff2_4</field_a>
+      <field_b>price_before_disc4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc2_5</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff2_5</field_a>
+      <field_b>price_before_disc5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc3_1</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff3_1</field_a>
+      <field_b>price_before_disc1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc3_2</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff3_2</field_a>
+      <field_b>price_before_disc2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc3_3</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff3_3</field_a>
+      <field_b>price_before_disc3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc3_4</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff3_4</field_a>
+      <field_b>price_before_disc4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc3_5</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff3_5</field_a>
+      <field_b>price_before_disc5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc4_1</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff4_1</field_a>
+      <field_b>price_before_disc1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc4_2</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff4_2</field_a>
+      <field_b>price_before_disc2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc4_3</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff4_3</field_a>
+      <field_b>price_before_disc3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc4_4</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff4_4</field_a>
+      <field_b>price_before_disc4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc4_5</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff4_5</field_a>
+      <field_b>price_before_disc5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc5_1</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff5_1</field_a>
+      <field_b>price_before_disc1</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc5_2</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff5_2</field_a>
+      <field_b>price_before_disc2</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc5_3</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff5_3</field_a>
+      <field_b>price_before_disc3</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc5_4</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff5_4</field_a>
+      <field_b>price_before_disc4</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <calculation>
+      <field_name>disc5_5</field_name>
+      <calc_type>PERCENT_1</calc_type>
+      <field_a>diff5_5</field_a>
+      <field_b>price_before_disc5</field_b>
+      <field_c/>
+      <value_type>None</value_type>
+      <value_length>-1</value_length>
+      <value_precision>-1</value_precision>
+      <remove>N</remove>
+      <conversion_mask/>
+      <decimal_symbol/>
+      <grouping_symbol/>
+      <currency_symbol/>
+    </calculation>
+    <attributes/>
+    <cluster_schema/>
+    <remotesteps>
+      <input>
+      </input>
+      <output>
+      </output>
+    </remotesteps>
+    <GUI>
+      <xloc>544</xloc>
+      <yloc>192</yloc>
+      <draw>Y</draw>
+    </GUI>
+  </step>
   <step_error_handling>
   </step_error_handling>
   <slave-step-copy-partition-distribution>