You need to sign in to do that
Don't have an account?

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