Skip to main content
Topics#Data ManagementAlastair Batchelor's Question
Alastair Batchelor (Thomsons Online Benefits) asked in #Data Management
Jun 29, 2016, 11:43 AM

Formula Field, nested IF statement

I'm looking to you formula experts for a bit of guidence here. I'm trying to get a nested IF statment working but I'm having trouble. I can make it work with just the first two but when I add in the third I just can't get it!

 

IF(ISBLANK(SBQQ__DefaultSubscriptionTerm__c), SBQQ__NetTotal__c,

 

IF(NOT(ISBLANK(SBQQ__DefaultSubscriptionTerm__c)),(SBQQ__NetTotal__c / SBQQ__Quote__r.SBQQ__SubscriptionTerm__c) * SBQQ__DefaultSubscriptionTerm__c,

 

IF(AND(NOT(ISBLANK(SBQQ__DefaultSubscriptionTerm__c))),NOT(ISBLANK(SBQQ__SegmentIndex__c)),SBQQ__NetTotal__c,0)))
3 answers
  1. Chris Duncombe (Imprivata)
    Jun 29, 2016, 11:54 AM
    The first two conditions for your formula are a bit redundent.

     

    Your saying IF(condition 1, do this, else IF NOT condition 1......     The else statement already implies its not condtion 1, so your check for NOT condition 1 really isnt needed.  I hope that makes sense

     

     

    IF(
         ISBLANK(SBQQ__DefaultSubscriptionTerm__c), 
         SBQQ__NetTotal__c,
         IF(
              NOT(ISBLANK(SBQQ__SegmentIndex__c)),
              SBQQ__NetTotal__c,
              (SBQQ__NetTotal__c / SBQQ__Quote__r.SBQQ__SubscriptionTerm__c) * SBQQ__DefaultSubscriptionTerm__c
         )
    )

     

     
Write an answer...
0/9000