SQL count calculation issue

[LynnR]

Hi.

I have a few SQL calculations that is counting data from my tables and views and giving me a number value. The problem is when calculation cannot find any results i always get a $0 insted of a clean 0 number value. how do i set this up the right way? This also only happens if i have not been assigned any projects. If you look at the picture you see what happens when i log in with nothing assigned..

SELECT COUNT
     (DISTINCT Projects_ProjectID)
FROM
     _v_Customer_addNotesToProjects 
WHERE
     Projects_Assigned_staff = '[@authfield:Users_UserID]' 
AND
     Project_Notes_Viewed = 'False'

[Vitalikssssss]

Hi @LynnR,

I would assume that your calculated field has currency formatting applied.

Make sure that your calculated field formatting set to "None" in order to remove currency sign.

Hope this helps.

Regards,

vitalikssssss

[LynnR]

On 4/11/2019 at 4:10 PM, Vitalikssssss said:

Hi @LynnR,

I would assume that your calculated field has currency formatting applied.

Make sure that your calculated field formatting set to "None" in order to remove currency sign.

Hope this helps.

Regards,

vitalikssssss

Hi, thanks for your suggestion, but my calculated fields already have the formatting set to none.

What i am trying to do is just count how many new follow-ups, projects and project comments that is assigned to one user. If you have the correct syntax to count these values and to show 0 when there is no values found it would be a great help.. 

 

[Vitalikssssss]

Hi @LynnR ,

Your query from the first post looks correct.

Try to play around with Localization settings on the field level.

 

Regards,

vitalikssssss

[RuisiHansamu]

Hi, you can also use this link for your reference in your SQL statements: https://www.w3schools.com/sql/sql_count_avg_sum.asp