Question

Hy Guys!I would like to count how many activities started from the year 2023 ?You know?

Forum|Forum|2 years ago
June 20, 2023
2 replies
0 views

Forum|alt.badge.img

+1

ariane.reis
Level 5

Hy Guys! I would like to count how many activities started from the year 2023 ? You know?

Forum|alt.badge.img

+14

dereck.garne13
Level 1
Forum|Forum|2 years ago
June 21, 2023

SUM(PU_COUNT("CASES_TABLE", "ACTIVITIES_TABLE"."ACTIVITIES", YEAR("ACTIVITIES_TABLE"."EVENTTIME") >= 2023))

Like

Forum|alt.badge.img

+6

kailash.potha12
Level 10
Forum|Forum|2 years ago
June 21, 2023

You can try - SUM (CASE WHEN YEAR("ACTIVITIES_TABLE"."EVENTTIME") >= 2023 THEN 1 ELSE 0 END )

Like