Post

1 follower Follow
1
Avatar

Relations Summary - Hours Posted in a month

Hello, I made a relations summary field at the project level to see the number of hours posted in the current month. The relation looks at the Timesheets.Duration. 

 

I wanted this field since looking at aggregated timesheets can be an eyesore and creates thousands of records in a single report.

I was able to make this, but the method I used does not scale. I am looking for a way for the formula to know it is "THIS MONTH".. Instead, I added the following logic until I find a way to make it work. For now, I will have to update the month number once the month ends. Any help is appreciated!

 

In(Month(TargetObject.ReportedDate),3) && In(Year(TargetObject.ReportedDate),2022)

Jamie Berger

Please sign in to leave a comment.