- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to distribut days
I'm working in a hotel and I need to distribut and sum the number of night on each Monty.
For example, a client stay since 28/12/2022 to 03/01/2023, (3 nights in december and 3 nights in January)
Now I can count the number of nights per Month, but I can't sum the total of nights for each Month.
Can you help me?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey there,
I guess your data table looks similar to this:
Guest | Arrival | Departure |
A | 27.12.2022 | 05.01.2023 |
B | 30.11.2022 | 01.12.2022 |
?
Then try:
Calendartable:
Crossjoin:
Best regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I'm having some problems when I wrote the querry:
I can't do it like you said.
Can you help me with the problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try to convert your check-in/check-out data in your reservas-data to date-type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have already done it but I can't execute the crossjoin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey there,
I guess your data table looks similar to this:
Guest | Arrival | Departure |
A | 27.12.2022 | 05.01.2023 |
B | 30.11.2022 | 01.12.2022 |
?
Then try:
Calendartable:
Crossjoin:
Best regards

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-17-2024 08:17 PM | |||
10-08-2024 04:56 AM | |||
12-11-2024 06:48 AM | |||
03-23-2024 05:20 AM | |||
Anonymous
| 11-06-2020 09:19 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |