Formula field not calculating a result

Question

Hey, I'm putting together a fomular field and must be missing something. I have a multiple IF statement that works when they are independent but when I have tried to combine the second IF section isnt calculating?

I'm not sure what I'm missing but I'm sure its something obvious!

IF(
AND(
SBQQ__Product__r.Include_in_PEPA__c,
NOT(ISBLANK(SBQQ__Group__c))),
(SBQQ__PackageTotal__c/SBQQ__Group__r.SBQQ__SubscriptionTerm__c *12)/ SBQQ__Quantity__c,
IF(
SBQQ__Product__r.Include_in_PEPA__c,
(SBQQ__PackageTotal__c/  SBQQ__Quote__r.SBQQ__SubscriptionTerm__c  *12)/SBQQ__Quantity__c,0))

Alastair Batchelor · Accepted Answer

got it, just relaised i was doing something very stupid indeed. Essentially i was referencing the object rather than the sepcific field in the object. Dim moment! Thanks for your help

Sunil Sarilla · Answer

Hi Alastair,   Looking at your formula, this what the formula will return   If Include in PEPA field is checked from the related SBQQ Product object (irrespective of whether SBQQ Group field is blank or not) the formula will return a value of   (SBQQ__PackageTotal__c/SBQQ__Group__r.SBQQ__SubscriptionTerm__c *12)/ SBQQ__Quantity__c else the formula return 0   is that what is expected?

Formula field not calculating a result

Data Management

Related Learning

More Help