Kris
Kris
Programming language:Whatever
2021-07-16 08:44:21
0
Q:

apex to calculate the average

AntonT
AntonT
Code: Whatever
2021-07-13 22:00:35 
(IF(ISNULL(Base_Q1__c),0,Base_Q1__c) + IF(ISNULL(Base_Q2__c),0,Base_Q2__c)+IF(ISNULL(Base_Q3__c),0,Base_Q3__c) +IF(ISNULL(Base_Q4__c),0,Base_Q4__c))
/
(IF(ISNULL(Base_Q1__c),0,1) + IF(ISNULL(Base_Q2__c),0,1)+IF(ISNULL(Base_Q3__c),0,1) + IF(ISNULL(Base_Q4__c),0,1)
0

Related

New to Communities?

Join the community