3 Replies Latest reply: Oct 21, 2013 5:02 PM by Aurélien Martinez RSS

    Problem with two variables

    Iñigo Elviro Bodoy

      Hello:

       

      I have problem with the use of two variables in a formula:

       

      1) vReception= Aggr ( Sum ({<TYPE={"Reception"}>} Quantity) MonthYear, Supplier) . Per example: 25.000 kg

       

      2) vClaim= Aggr ( Sum ({<TYPE={"Claim"}>} Quantity) MonthYear, Supplier) . Per example: 1000 kg

       

      When I calcul in an expression:

       

      %=$(vClaim)/$(vReception) the result is only the first formul: 1000 kg instead of 1000/25000= 0,04


      The result is like only use the first formul an forget to divide by the second.

       

      The table is:

       

      MonthYearSupplierTypeQuantity
      01/2013AReception25000
      01/2013AClaim1000

       

      Thanks in advance.