@DbLookup & @DbColumn do not return negative or zero value

HCL Domino Domino Forum
1

Hi,

I am starting to pull my hair. Simple Formula.

I have a view with two columns. Using DbColumn I am pulling all values in column 2. View has total of 25 records. 1 record out of those 25 has 0 value in column 2 and 1 has negative number (-100) in column 2. When lookup is performed Both DbLookup and DbColumn return all values except the zero and negative number. I cannot figure out why. Help is greatly appreciated.

2

Subject: @DbLookup & @DbColumn do not return negative or zero value

Please post your column formula and your DbLookup / DbColumn formula so we can get a better understanding of what you are doing and therefore might be able to better assist you.

Alex