Setting up a count off of different date rules in ETL
I'm trying to set up a column that would show me how many workdays to pay a consultant for, depending on how many days they worked for over the month.
The variables are whether the start or end date was during that month (and so they would only be comped for that part of the month - from start to month end of form month start to work end).
I've tried to set up an ETL process to give me the month and year for different date points to compare against one another to see which rule should apply. I then tried to set up a case to give me the relevant number of workdays from different columns in the data set, depending on the situation (below), but keep getting a syntax error message.
Any ideas on how I could make this work?
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board