Skip to main content
I have a custom object.... Online Applications with 2 Page Layouts:

 

XYZ vendor

 

- inputs monthly_payment_c in a currency field

 

- formula field:  capitalized_amount = (Monthly_Payment__c*12)/0.0995

 

123 Vendor 

 

- inputs total_amount_financed_c in a currency field

 

- formula field: monthly_payment =  (Total_Amount_Finanaced__c*0.0995)/12

 

I have reports and dashboards for each.... I would like to make it so...

 

OR (IF (123 vendor = false, total_amount_financed > 0, total amount_financed, capitalized_amount))

 

....then I could consolidate the reports

 

.... formula doesn't work

 

... SteeMO...  you out there??
1 件の回答
  1. 2014年11月6日 4:45
    Do you have a mockup of the report you're trying to display? Which fields are you trying to report on and what needs to be combined?

     

    Just speaking of your formula alone, there looks to be a syntax issue... an IF formula should have 4 parameters and Or should have at least two. So if you wanted an IF inside an OR, if would look more like this:

     

    OR(

     

    IF(something evaluates to true, then use this value, else use this value),

     

    or this value)

     

    Perhaps this is what you were going for?

    IF (OR(123 vendor = false, total_amount_financed > 0), total amount_financed, capitalized_amount)

     

    That says if 123 vendor = true OR total amount financed > 0, then use total amount financed, else use capitalized amount for all other scenarios