BookmarkSubscribeRSS Feed
user34567
Obsidian | Level 7

Hi all,

I have created this calculation to show the number of hours in 2024 and added it to my list table:

 

IF ( 'Document_date_year'n = '2024'd )
RETURN (
IF ( 'Hours'n Missing )
RETURN 0
ELSE 'Hours'n )
ELSE 0

It works, but it shows the number of hours for each time a person entered their hours instead of just a count for each person.

Thats why I created a crosstab instead so that it sums the total number of hours per person. But now the above calculation is not working and it just shows 0.

 

List table output

Person A8
Person A8
Person A8
Person B8
Person B8
Person C8
Person C4

 

Desired output

Person A24
Person B16
Person C12

 

Does someone understand why this happens?

 

Thanks in advance!

2 REPLIES 2
Astounding
PROC Star

What language are you programming in?

user34567
Obsidian | Level 7
English (United Kingdom)