You need to sign in to do that
Don't have an account?
GYAN ANDRUS
Can anyone help for this,I am taking the peer__Amount_Funded__c (number field) where status is funded ,I need sum all the values ,but it is not working
I need to sum all the value of peer_amount_funded__c .
And i have created the custom field in custom Setting Base_value__c..I want to sum all the value of peer_amount__c and add it to base_value__C..Please help me on this
for (Account obj : [select id,Total_Amount_Funded__c, ( Select Id,name,peer__Amount_Funded__c from peer__Loan_Application__r where status__c =' Funded' ) from Account Where Type='Borrower'])
{
Decimal total_amt = 0.0;
for(peer__Loan_Application__c temp : obj.peer__Loan_Application__r){
total_amt = total_amt + temp.peer__Amount_Funded__c;
}
obj.Total_Amount_Funded__c = total_amt;
system.debug('LOAN DISBURSED SO FAR -----------:'+total_amt);
}
And i have created the custom field in custom Setting Base_value__c..I want to sum all the value of peer_amount__c and add it to base_value__C..Please help me on this
for (Account obj : [select id,Total_Amount_Funded__c, ( Select Id,name,peer__Amount_Funded__c from peer__Loan_Application__r where status__c =' Funded' ) from Account Where Type='Borrower'])
{
Decimal total_amt = 0.0;
for(peer__Loan_Application__c temp : obj.peer__Loan_Application__r){
total_amt = total_amt + temp.peer__Amount_Funded__c;
}
obj.Total_Amount_Funded__c = total_amt;
system.debug('LOAN DISBURSED SO FAR -----------:'+total_amt);
}
You can use below mentioned code to achieve this. Please update the custom setting name with the one you created in your org:
Decimal total_amt = 0.0;
for (Account obj : [select id,Total_Amount_Funded__c, ( Select Id,name,peer__Amount_Funded__c from peer__Loan_Application__r where status__c =' Funded' ) from Account Where Type='Borrower'])
{
for(peer__Loan_Application__c temp : obj.peer__Loan_Application__r){
total_amt = total_amt + temp.peer__Amount_Funded__c;
}
system.debug('LOAN DISBURSED SO FAR -----------:'+total_amt);
}
insert new CustomSetting__c(Base_value__c = total_amt);
If your intention is to add the basevalue of custom field to the totalAmount field then you can do something like this:
Decimal total_amt = 0.0;
CustomSetting__c obj = CustomSetting__c.getInstance('Name'); //fetch the instance of custom setting that contains the base value
for (Account obj : [select id,Total_Amount_Funded__c, ( Select Id,name,peer__Amount_Funded__c from peer__Loan_Application__r where status__c =' Funded' AND peer__Amount_Funded__c!=NULL) from Account Where Type='Borrower'])
{
for(peer__Loan_Application__c temp : obj.peer__Loan_Application__r){
total_amt = total_amt + temp.peer__Amount_Funded__c;
}
system.debug('LOAN DISBURSED SO FAR -----------:'+total_amt);
}
total_amt +=obj.BaseValue__c+total_amt;// add base value to total amount.
system.debug('=================='+total_amt);
obj.BaseValue__c = total_amt;//assign total amount field value to base value
update obj;//update the base value in custom setting.
Please refer the above mentioned highlighted statements and let us know in case of any issues.
Decimal total_amt = 0.0;
Base_live_funded_amount__c obj1 = Base_live_funded_amount__c.getInstance('Base_Live_Amount_funded_so_far__c');
for (Account obj : [select id,Total_Amount_Funded__c, ( Select Id,name,peer__Amount_Funded__c from peer__Loan_Application__r where status__c =' Funded' AND peer__Amount_Funded__c!=NULL) from Account Where Type='Borrower'])
{
for(peer__Loan_Application__c temp : obj.peer__Loan_Application__r)
{
total_amt = total_amt + temp.peer__Amount_Funded__c;
}
system.debug('LOAN DISBURSED SO FAR -----------:'+total_amt);
}
total_amt +=obj1.Base_Live_Amount_funded_so_far__c+total_amt;// add base value to total amount.
total_amt = obj1.Base_Live_Amount_funded_so_far__c ; //assign total amount field value to base value
system.debug('=================='+total_amt);
Got error,,attempt to dereference a null object