+ Start a Discussion
kjpetersonkjpeterson 

Does rollup criteria exclude null value records when using Some_Field Not Equal To Some_Value

We have a rollup on Opportunity for Opportunity Products with criteria checking that a percent field is not equal to 100.

 

Sales_Discount__c Not Equal To 100

 

This is causing us issues because records that have a blank Sales_Discount__c value are being excluded.  If we put a zero or some other value then it gets included in the rollup fine.

 

Does this sound correct or are we missing something else?

AdrianCCAdrianCC

Yes it it correct. Try to set a defaul value on that field, like 0 or what ever seems logical.

 

Thank you,

Adrian