I want to make a formula field (ARR)
If the Final Booking Value is NOT Blank then the Final Booking Value/Term X 12.
If the Term is Blank then Final Booking Amount/36 X 12.
or
Null Value if the Final Booking Value is missing otherwise Final Booking Value/Term X 12
If the Term is Blank then Final Booking Amount/36 X 12.
Eg final booking is 360 and the Term is 36 therefore ARR is 360 / 36 x 12 = 120
Thank you,
Tarun
5 answers
I figured it out on my own.
Below is what I used
IF( ISBLANK( Final_Term__c ) , Final_Booking_Value__c / 36 * 12, Final_Booking_Value__c / Final_Term__c * 12 )
I also selected "Blank Field Handling"
Thank you,
Tarun
