0

I have a number of fields on the Case object that are part of a field that is totalled:

IF( 

NOT( 

AND( 

Interpreter_Pay__c == null, 
Nurse_Pay_Rate__c == null, 
Interpreter_Hours__c == null, 
Interpreter_Travel_Fee__c == null, 
Site_Fee__c == null, 
Administrative_Fee__c == null 
) 
), 

Interpreter_Pay__c * Interpreter_Hours__c 
+ Nurse_Pay_Rate__c * Interpreter_Hours__c 
+ Site_Fee__c 
+ Administrative_Fee__c 
+ Interpreter_Travel_Fee__c 

,null)

The field calculates properly on the case detail page but when generating a report shows - on all records . Is there some limitation to salesforce stopping me here or have I missed something?

edit: none of the fields in the formula are formulas themselves; each will be manually entered.

4
  • Did you run the report? In the preview sometimes formula fields do not display the data.
    – raym0nd
    Apr 4, 2016 at 15:52
  • Running the report returns - also
    – JaredT
    Apr 4, 2016 at 15:53
  • Are you running the report as an admin? Is it possible to have permission issues?
    – raym0nd
    Apr 4, 2016 at 15:55
  • I am an admin of the org, incredibly unlikely to be a privilege issue
    – JaredT
    Apr 4, 2016 at 15:55

1 Answer 1

1

IF( AND( ISNULL(Interpreter_Pay__c), ISNULL(Nurse_Pay_Rate__c), ISNULL(Interpreter_Hours__c), ISNULL(Interpreter_Travel_Fee__c), ISNULL(Site_Fee__c), ISNULL(Administrative_Fee__c) ), NULL, Interpreter_Pay__c * Interpreter_Hours__c + Nurse_Pay_Rate__c * Interpreter_Hours__c + Site_Fee__c + Administrative_Fee__c + Interpreter_Travel_Fee__c )

2
  • This worked for me, thank you! Would you mind explaining the difference to me and why the original formula would work on detail page but not in report?
    – JaredT
    Apr 4, 2016 at 17:21
  • 1
    I'm not sure why it was not working for you, it might be related to how SF is treating some validations: they have ISNULL() formula that supposed to be used for any null or blank values validations
    – o-lexi
    Apr 4, 2016 at 17:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .