3 Replies Latest reply: Dec 26, 2016 3:06 AM by Payal Shah RSS

    Total amount in terms of specific variables in the script

    Majid Ghabooli

      Hi

      please guide me

      I have table similar below :

       

      Ord_NoInv_NoGroupe_CodeBrand_CodeGood_CodeQuantityAmount
      AT950111ATOMICAT_9501501000000
      AT950111ATOMICAT_95061002130000
      AT950122ATOMICAT_95881202500000
      NK950113NIKENK_32882003200000
      NK950113NIKENK_65281805200000
      NK950124NIKENK_14782004100000
      SA950111SALAMONSA_32141507400000
      SA950111SALAMONSA_65471656500000
      SA950212SALAMONSA_36982105600000
      SA950224SALAMONSA_2587665800000
      SA950224SALAMONSA_9632506900000

       

      I need total breakdown of order number ( Ord_No ) and invoice number ( Inv_No ) ???

       

      In a expression to this form of writing :

      sum ( Amount ) / sum ( TOTAL< Ord_No , Inv_No > Amount )

       

      Please advise me what code to write the script as new variable ???

      Thank you