I have a formula field with return type 'currency' and it uses a custom setting field in formula
Formula is something like this :-
IF(AND(Invoice_Date__c < $Setup.New_Cust_Sett__c.date_field__c , Amount_Remaining__c != 0), IF(AND( $Setup.New_Cust_Sett__c.date_field__c -Invoice_Date__c > 1, $Setup.New_Cust_Sett__c.date_field__c -Invoice_Date__c <= 30), Amount_Remaining__c , 0.00) ,0.00)
I need to summarize on the result of this field in a parent object field. And i can see Rollup summary on cross object formula field is not possible till now. https://success.salesforce.com/ideaview?id=08730000000Bra0AAC
So does someone know any alternative of this?
Any help would be really appreciated!!!