grid total not coming for field by sql look up

Applications Grid / Reports
,
#1

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

🚀 Scriptcase 9.12 is now available! Check out the new features here 👉🚀 Next Monday (02/24), Scriptcase 9.12 will be released! Check out the new features before anyone else 👉