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)

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Discussion stats
  • 2 replies
  • 310 views
  • 0 likes
  • 2 in conversation