Skip to main content
Topics#Data ManagementAfolabi Onanuga의 질문
Afolabi Onanuga (Cloudsquare) 님이 #Data Management에 질문했습니다
2015년 11월 5일 오전 3:02

Formula for when fields are not completed

Hey guys this formula works well however, How do i make it work when fields aren't completed E.g

 

Formula for when fields are not completed

 

I'm thinking ISblanks but I don't know where to start.

 

Conversions__c * IF( Conversions__c < Account__r.Benchmark_Conversions_1__c, 0, IF( Conversions__c <  Account__r.Benchmark_Conversions_2__c,  Account__r.Target_1_CPA__c ,  Account__r.Target_2_CPA__c))

 

+

 

IF( Conversions__c < Account__r.Benchmark_Conversions_1__c, Account__r.Flat_Amount__c, IF( Conversions__c <  Account__r.Benchmark_Conversions_2__c,  Account__r.Target_1_Flat__c ,  Account__r.Target_2_Flat__c ))

 

Thanks in advance.
답변 2개
  1. Afolabi Onanuga (Cloudsquare)
    2015년 11월 5일 오전 3:06
    A good example will be if Target 1 CPA is field but not target 2
답변을 작성하세요...
0/9000