Reports is not able to track custom currency fields with null value.

Hello everyone,

I am building a report that analyzes data of account records and gives number of accounts which do/don’t have data filled in for 4 fields. And I amclassifying the number of accounts into three categories as Full, Partial and Missing.

 

‘Full’ if all 4 fields are filled, ‘Partial’ if at least one field of all the 4 fields is filled and ‘Missing’ if all 4 fields are not filled.

 

Of the 4 fields, there is one custom currency field that’s creating problem.

 

The report works fine when I am not considering that custom currency field and it also works fine when I am considering ‘Account Revenues’ a system currency field instead of my desired custom currency field.