Hy Guys!
I would like to count how many activities started from the year 2023 ?
You know?
Page 1 / 1
SUM(PU_COUNT("CASES_TABLE", "ACTIVITIES_TABLE"."ACTIVITIES", YEAR("ACTIVITIES_TABLE"."EVENTTIME") >= 2023))
You can try - SUM (CASE WHEN YEAR("ACTIVITIES_TABLE"."EVENTTIME") >= 2023 THEN 1 ELSE 0 END )
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.