Skip to main content
14 answers
  1. Jun 18, 2014, 11:37 AM
    Now i Got...

     

    trigger TesTRollUP on Store__c (after insert,after update) {

     

       set<ID> sid = new set<ID>();

     

       list<NewSpace__Shopper__c> ns= new list<NewSpace__Shopper__c>();

     

      

     

       Integer tot =0;

     

        

     

          

     

           for(NewSpace__Store__c s : [select id ,NewSpace__Shopper__c,NewSpace__Marks__c from NewSpace__Store__c where id in : Trigger.newMap.keySet() ])

     

            {

     

           

     

             sid.add(s.NewSpace__Shopper__c);

     

           

     

            }

     

           

     

           

     

           for(NewSpace__Store__c ss : [select id,NewSpace__Marks__c  from NewSpace__Store__c  where NewSpace__Shopper__c IN : sid ])

     

           {

     

          

     

            tot+=Integer.valueof(ss.NewSpace__Marks__c);

     

          

     

           }

     

          

     

           for(NewSpace__Shopper__c nss:[select id,NewSpace__Total_Store_Marks__c from NewSpace__Shopper__c where id in:sid  ])

     

          

     

           {

     

              nss.NewSpace__Total_Store_Marks__c =tot;

     

              ns.add(nss);

     

          

     

          

     

           }

     

        update ns;

     

       

     

    }
0/9000