8 Replies Latest reply: Dec 3, 2015 2:13 AM by Tatsiana Chetirbok RSS

    Mapping in/between the fields in order to do the calculations

      Hi all,

      I need to create a mapping like this.

      plant nameprint center1print line1print center2print line2

      D1

      33CUX345P-2C32CUX345PCO-2C
      D133CUX363P-4C32CUX363PCO-4C
      F133LAFP02P-6C32LAFP02PCO-6C
      I133INCB79P-6CFOV32INCB79PCO-6CFOV

      For each plant, by using this mapping, I should calculate the volume of print line1 divided by the volume of print line2. The calculation should also be available at print center niveau.

      All the "print center1 and print center2" (e.g. 33CUX345) are the different elements in the same field"print center".

      and all the "print line1 and print line2" are the elements of the same field "print line".

       

      what i wrote down in the script :

      Print:

      LOAD * INLINE [

      _plant, _print_c1, _print_lin1, _print_c2, _print_lin2,

      D1, 33CUX345, P-2C, 32CUX345, PCO-2C

      ...

      ...

      ]

       

      The current expression is :

      sum({<Version='Actual', Year='2015', Department_code={3}, _Print_lin1={*}, _Print_c1={*}>}Volume)/sum({<Version='Actual', Year='2015', Department_code={9}, _Print_lin2={*}, _Print_c2={*}>}Volume)

       

      To separate the print centre1 and 2, i use their "department_code" ("3" is print center1 and "9" is center2).

      For now the calculations don't work...

       

      Does anybody know where the problem is? in the script or in the expression or in both of them?

      Many thanks.

       

      Ce message a été modifié par : Q H