Skip to main content
Topics#Data ManagementSteve Andruszka's Question
Steve Andruszka asked in #Data Management
Jul 23, 2014, 4:36 AM

Formula

Hoping someone can help me figure this formula out.  What I'm trying to do is say if the Acquired Date +180 days is greater than or equal to today, then multiply the Original Cost * .025 * the number of months since the Acquired Date - 6 months (formula below).  I'm getting some really weird results and I'm sure it's a paran placement or something

 

IF((Acquired_Date__c + 180 < TODAY()),

 

(Original_Cost__c * 0.025*

 

((((YEAR(TODAY()) - YEAR(Acquired_Date__c) - 1) *12) + (12 - MONTH(Acquired_Date__c) +1) + MONTH(TODAY())))-6),

 

0)

 

For example, if the Acquired date is 9/25/2013 and the Original Cost is $83,300.00, then the calculation should be:

 

83,300 * 0.025 * 4 (Today - 9/25/2013 in months - 6 months) = $8,330

 

Thanks!
2 answers
  1. Vamsi Gosu (TechForce Services)
    Jul 23, 2014, 4:46 AM
    Steve,

     

    you can try this and see if it works..

     

    the diference between dates will give you number of days and we can divide by 30 for a rough number of months

     

    IF(
      (Acquired_Date__c + 180) < TODAY(),
      Original_Cost__c * 0.025*(((TODAY() - Acquired_Date__c)/30)-6),
      0
    )
Write an answer...
0/9000