0

The current formula is:

((( DATE(2023,11,30)- ( Production_Live_Date__c )+ 30.43685))/ 30.43685)* List_price_MRR__c

  • Effectively calculates the in-year revenue forecast based on the go-live date in the current year.

I need to add an if-statement to make deals which go live in 2024 = $0, Please help :)

2 Answers 2

0

IF(NOT(ISBLANK(Production_Live_Date__c)) && YEAR(Production_Live_Date__c) == 2024,0,(((( DATE(2023,11,30)- ( Production_Live_Date__c )+ 30.43685))/ 30.43685)* List_price_MRR__c))

1
  • Thanks! This worked!
    – Ft2711
    Jul 17, 2023 at 12:04
0

Try below:

IF(
  YEAR(Production_Live_Date__c) >= YEAR(TODAY()),
  0,
  (((DATE(2023, 11, 30) - Production_Live_Date__c + 30.43685)) / 30.43685) * List_price_MRR__c
)

Instead of using 2024 as hardcoded you can make it generic. Do the same for 2023 date based on your requirement.

You must log in to answer this question.

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