function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
raju.Braju.B 

for loop to add column values

Hi,

Im new to salesforce..

 

I displayed all records of an object in Vf page

I need to display a subtotal of first column of all records..

 

CAn any one tell me the login for it.

 

 

Thanks,

 

Ravi

Shashikant SharmaShashikant Sharma

Use a wrapper class and add items to list  of wrapper items, 

then aslo calculate sum that you want on each entry.

Sum = Sum + new Value;

 

Add a final item with sum in wrapper. 

 

show list of wrapper in VFP
raju.Braju.B

Hi,

 

Thanks for the reply...

Actually i have sent u the code which i have tried .

im getting a garbage value..

 

 

Thanks & Regards,

 

Raju.B
raju.Braju.B

 

public class display
{
decimal sum1=0;
decimal sum2=0;
decimal sum3=0;
decimal sum4=0;
public decimal a{set;get;}
public decimal a1{set;get;}
public decimal a2{set;get;}
public decimal a3{set;get;}
public string EmploeeCodeEnterd{set;get;}
public List<SelectOption> getitems() { 
List<SelectOption> options = new List<SelectOption>();
options.add(new SelectOption('None','None'));
for(Tantousha__c bb:[select id ,name from Tantousha__c])
{
 if(bb.id!=null && bb.name!=null)
 {
 options.add(new SelectOption(bb.id,bb.name));
 }
 }
 return options; 
  
 }
public boolean namesform{set;get;}
list<YojituMikomi__c> ylist=new list<YojituMikomi__c>();
public YojituMikomi__c yoj{set;get;} 
public display()
{
namesform=true;
 for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,
                    
  YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false
                    AND Tantousha__c =: EmploeeCodeEnterd])
  {
  ylist.add(y);
  
  }               
           
}
public list<YojituMikomi__c> getyoj_data()
{
return ylist;
}
public void save()
{
for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,
                    
  YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false
                    AND Tantousha__c =: EmploeeCodeEnterd])
  {
 
   sum1+=y.TougetuMikomiShouhin__c;
   sum2+=y.TougetuMikomiSeihin__c;
   sum3=+y.YokugetuMikomiShohin__c;
   sum4+=y.YokugetuMikomiSeihin__c;
}
a=sum1;
a1=sum2;
a2=sum3;
a3=sum4;
update ylist;
}
}

public class display{decimal sum1=0;decimal sum2=0;decimal sum3=0;decimal sum4=0;
public decimal a{set;get;}public decimal a1{set;get;}public decimal a2{set;get;}public decimal a3{set;get;}
public string EmploeeCodeEnterd{set;get;}
public List<SelectOption> getitems() { List<SelectOption> options = new List<SelectOption>();options.add(new SelectOption('None','None'));for(Tantousha__c bb:[select id ,name from Tantousha__c]){
 if(bb.id!=null && bb.name!=null) { options.add(new SelectOption(bb.id,bb.name)); } } return options;    }public boolean namesform{set;get;}list<YojituMikomi__c> ylist=new list<YojituMikomi__c>();public YojituMikomi__c yoj{set;get;} public display(){namesform=true; for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,                      YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false                    AND Tantousha__c =: EmploeeCodeEnterd])  {  ylist.add(y);    }                          }public list<YojituMikomi__c> getyoj_data(){return ylist;}public void save(){
for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,                      YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false                    AND Tantousha__c =: EmploeeCodeEnterd])  {  //decimal aa=sum(y.TougetuMikomiShouhin__c);   //sum2=sum(y.TougetuMikomiSeihin__c);   //sum3=sum(y.YokugetuMikomiShohin__c);   //sum4=sum(y.YokugetuMikomiSeihin__c);   sum1+=y.TougetuMikomiShouhin__c;   sum2+=y.TougetuMikomiSeihin__c;   sum3=+y.YokugetuMikomiShohin__c;   sum4+=y.YokugetuMikomiSeihin__c;}a=sum1;a1=sum2;a2=sum3;a3=sum4;update ylist;}}

 
raju.Braju.B

 

public void save()
{
for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,
                    
  YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false
                    AND Tantousha__c =: EmploeeCodeEnterd])
  {
 
   sum1+=y.TougetuMikomiShouhin__c;
   sum2+=y.TougetuMikomiSeihin__c;
   sum3=+y.YokugetuMikomiShohin__c;
   sum4+=y.YokugetuMikomiSeihin__c;
}
a=sum1;
a1=sum2;
a2=sum3;
a3=sum4;
update ylist;
}

public void save(){
for(YojituMikomi__c y: [SELECT Torihikisaki__r.Name,TougetuMikomiShouhin__c,TougetuMikomiSeihin__c,YokugetuMikomiShohin__c,                      YokugetuMikomiSeihin__c, Tantousha__c, NenGetu__c FROM YojituMikomi__c WHERE IsDeleted = false                    AND Tantousha__c =: EmploeeCodeEnterd])  {  //decimal aa=sum(y.TougetuMikomiShouhin__c);     sum1+=y.TougetuMikomiShouhin__c;   sum2+=y.TougetuMikomiSeihin__c;   sum3=+y.YokugetuMikomiShohin__c;   sum4+=y.YokugetuMikomiSeihin__c;}a=sum1;a1=sum2;a2=sum3;a3=sum4;update ylist;}