I need this formula to calculate the current year expected profit if the close date was today.
If I dived the Gross Margin by 365. Then subtract the 18 days I need to calculate based on the remaining days of the year. I am fairly new to Salesforce and formulas. So far I have come up with the below formula but it's not producing the results I need. Any help is greatly appreciated.
IF( YEAR( CloseDate ) = YEAR(TODAY()), Gross_Margin__c , 0 )
9 respuestas
Gah! missed a ( paren
Gross_Margin__c *
IF(
YEAR( CloseDate ) = YEAR(TODAY()),
(( DATE(YEAR(TODAY()) + 1, 01, 01) - TODAY() ) / 365),
0 )
