[V4MD ver 1.9.8] using Sum() returns a null value

[Mahesh Markus]

I am using the aggreate function SUM() as in the following query:
    SELECT Sum(number)
    FROM tblInformation
    WHERE tblInformation.ID = 23
 
Howver, both avg() and count() work.
 
I am temporarily using avg() * count() to get the correct figure.
 
Any suggestions.
 
Thanks in advance,
 
mahesh