function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Bhola VishwakarmaBhola Vishwakarma 

getting an error

the error i am getting is

 

Unable to make this formula automatically derived because it is used in the following roll-up summary field(s): Account.Investment Asset Rollup. To continue, remove any references to derived values such as the current date, current user, or user-role

Error: Invalid Data.
Review all error messages below to correct your data.

 

i am haveing an problem in my formula field i am not able to put the advance fromula in my formula field so 

what should i do to  remove this error 

 

following is  my custom objects(Investment_Asset__c) in which i have to give formula to TotalAsset__c

Allocated_Amount__c	               Roll-Up Summary (SUM GoalInvestmentAssetAssociation)
AMC_Name__c	                       Lookup(AMC Name)
Entity__c	                       Master-Detail(Account)
Face_Value__c	                       Number(15, 3)
fixedIncomesValue__c	               Formula (Currency)
Fund__c	                               Lookup(Fund) 
FundValue__c	                       Formula (Currency)
Maturity_Date__c	               Date
Maturity_Value__c	               Number(18, 0)
Monthly_SIP_Amount__c	               Currency(18, 0)
Remove_Checkbox__c	               Checkbox
Scheme_Name__c	                       Text(40)
Scheme_Type__c	                       Picklist
Script_Name__c	                       Text(40)
SIP_Date__c	                       Date
Stock_Value__c	                       Formula (Currency)
Total__c	                       Currency(18, 0)
TotalAsset__c	                       Formula (Currency)
Units__c	                       Number(15, 2)



another custom object which is rollupSummary is GoalInvestmentAssetAssociation__c in this i have
allocated__c	       Percent(16, 2)
Allocation__c	       Number(16, 2)
Goal__c	                Master-Detail(Goal)
GoalYearValue__c	Number(16, 2)
Investment_Asset__c	Master-Detail(Investment Asset)

 your help would do a lot of good for me