+ Start a Discussion
GunnarGunnar 

Report Issue: Null vs zero

REPORT ISSUE:

 

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?

 

Thx.

Best Answer chosen by Admin (Salesforce Developers) 
GunnarGunnar

Adjusting report type solved the problem.