function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Zoren DomingoZoren Domingo 

formula field, set default value to 0.

Hi, can anyone help me on making this formula, defaul to 0, if values are blank.

(ROUND((NULLVALUE( Primary_KPI__c , 0) * (0.3 + Adjustment_Factor__c )) + 
      (NULLVALUE( Secondary_KPIs__c,0 ) * (0.1+ Adjustment_Factor__c)) + 
      (NULLVALUE( Client_Satisfaction__c,0 ) * (0.3+ Adjustment_Factor__c)) + 
      (NULLVALUE( Target_Quality__c,0 ) * (0.3+ Adjustment_Factor__c)),1)
Raj VakatiRaj Vakati
Try this 
  
(ROUND((ISBLANK( Primary_KPI__c), 0 ,Primary_KPI__c ) * (0.3 + Adjustment_Factor__c )) + 
      (ISBLANK( Secondary_KPIs__c),0 ,Secondary_KPIs__c) * (0.1+ Adjustment_Factor__c)) + 
      (ISBLANK( Client_Satisfaction__c),0 ,Client_Satisfaction__c) * (0.3+ Adjustment_Factor__c)) + 
      (ISBLANK( Target_Quality__c),0,Target_Quality__c) * (0.3+ Adjustment_Factor__c)),1)

 
Zoren DomingoZoren Domingo
Error: Incorrect number of parameters for function 'ISBLANK()'. Expected 1, received 2
Raj VakatiRaj Vakati
tty like this
  
(ROUND((IF(ISBLANK( Primary_KPI__c), 0 ,Primary_KPI__c)

 
Raj VakatiRaj Vakati
(ROUND((IF(ISBLANK( Primary_KPI__c), 0 ,Primary_KPI__c) * (0.3 + Adjustment_Factor__c )) + 
      (IF(ISBLANK(( Secondary_KPIs__c),0,Secondary_KPIs__c) ) * (0.1+ Adjustment_Factor__c)) + 
      (IF(ISBLANK(( Client_Satisfaction__c),0 ,Client_Satisfaction__c) * (0.3+ Adjustment_Factor__c)) + 
      (IF(ISBLANK(( Target_Quality__c),0,Target_Quality__c ) * (0.3+ Adjustment_Factor__c)),1)