2 Replies Latest reply: Apr 20, 2018 4:02 AM by Capricon User RSS

    logic

    Capricon User

      I have this type of data

       

      HEAD                            TYPE                   EXP_TYPE         CODES            

      ADSPNGE751-71510%  to IE
      ADSPNAE751-71610% IE

       

      above tables shows that 10 % goes to IE and other goes to GE 

      and in second row 10% go to IE and other 90% go to AE i.e. we must total to 100% not above 100

       

      now here in below that how i distributed % according to above table to make 100% because above table shows that 90% to AE 90% TO GE and 10 % to IE  this because around 190 but i want to make this 100 how i do this or is there any formula we apply to make total 100 %

      AND THIS ANOTHER SHEET

           

       

      headLEAEGETEIE
      ADS909010