+ Start a Discussion

Report Issue: Null vs zero



The fields are defined numeric(4,0), no default value.


The records and fields are created/populated via apex.


My interest is only in fields where a WRITTEN value of zero (0) is created.


I'm not interested in records where I wrote some other value other than -0-.


I do have fields with a null, and this is correct, I did not write a value.


When I filter, I say where the field = 0.


Run the report, and I get records with 0 and with NULL.


Don't want that, just 0 - zero.


Any ideas?



Best Answer chosen by Admin (Salesforce Developers) 

Adjusting report type solved the problem.