Hi All,
Hoping someone might be able to help, I'm building a report and think I need to transpose the columns into rows or do some sort of crosstab, please see below for an example of the data I'm getting:
ID
1
2
3
4
5
6
85435
0
7.5
0
7.5
0...
I've moved to ' to ' concat to be before the end date range rather than at the end of the start date so it fixes the to being printed on a single date:
Not sure how to add "day(s)" at the end of that, if its the first record and the last record then print "DATE x day(s)
Hi Pete,
I've only had a chance to test the formulas today, I'm really sorry for not getting back to you earlier and I genuinely appreciate you going through the effort and trying to help.
Please see below for results I got so far, this report runs through the whole employee database, I think...
Sorry I'm not sure how a work day calendar helps in this case, I'm trying to achieve something similar to this, the report pulls absence details from a database I just need it to display as from - to if consecutive days and then count the number of instances.
Hi everyone,
I'm trying to create a report which looks at dated records and displays them as ranges then counts the individual ranges and the number of records. Report is grouped by ID. Selection is based on date ranges and record type.
Data example:
ID: Dated:
21 01/12/2023
No record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.