grid total not coming for field by sql look up

if my numeric value of field comes from sql loook up settings,why grid total do not come? static group by also i cant create for simple sum. plz see attachment
thanks,

group-by.png