You can see in the table that it retrieves 2.349,0 from database (not 2349).

PS: Do you use "Columns settings -> Format" parameter in module settings?

Regards,
ARI Soft

I disagree
I am convinced, that my MSSQL returns ingeter.

Where can i learn about formatting parameters?

Not using any formatting parameters.


Sincerely
Johnny Ejs

The extension can modify data only if "Format" parameter is defined otherwise data is modified outside the extension. We need to see the problem and have access to backend so we can investigate it because we can't reproduce it on our test server.

Regards,
ARI Soft

Solved!
And You were right again.

This modification to Query fixed my problem:

SELECT Dep.a as Forv
,cast((SELECT COUNT(*) FROM dbo.HPD_Help_Desk with (nolock) WHERE [Categorization_Tier_1] = 'Change' AND [Categorization_Tier_2] like '%Normal%' AND [Department] = Dep.a) as varchar(250)) as Normal
FROM (SELECT 'BIF' a union all SELECT 'BUF' a union all SELECT 'KFF' a union all SELECT 'KS' a union all SELECT 'SUF' a union all SELECT 'SOF' a union all SELECT 'TMF' a ) as Dep

union all
SELECT N'ØKF' as Forv
,cast((SELECT COUNT(*) FROM dbo.HPD_Help_Desk with (nolock) WHERE [Categorization_Tier_1] = 'Change' AND [Categorization_Tier_2] like '%Normal%' AND [Department] like '%KF') as varchar(250)) as Normal

So this issue can be closed.
Sincerely - Johnny Ejs