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 A | 8 |
Person A | 8 |
Person A | 8 |
Person B | 8 |
Person B | 8 |
Person C | 8 |
Person C | 4 |
Desired output
Person A | 24 |
Person B | 16 |
Person C | 12 |
Does someone understand why this happens?
Thanks in advance!