-
1. Re: Need help with a new calculation with date fields
Jamieson Christian Mar 21, 2017 1:53 PM (in response to Kevin Stinnett)Kevin,
It looks like the ranges in your reference table are inclusive, so your formula probably needs to look like this instead:
if [Post Date] >= [Start Date] and [Post Date] <= [End Date]
then [Fisc Year Per]
else null
END
-
2. Re: Need help with a new calculation with date fields
sns tab Mar 21, 2017 1:54 PM (in response to Kevin Stinnett)Can you please share workbook.
-
3. Re: Need help with a new calculation with date fields
Kevin Stinnett Mar 22, 2017 10:24 AM (in response to sns tab)I added the workbook to the original post. Thanks
-
4. Re: Need help with a new calculation with date fields
Kevin Stinnett Mar 22, 2017 10:25 AM (in response to Jamieson Christian)I apologize. I should have had that originally. However, if adding the greater than or equal to and the less than and equal to didn't change the issue.
-
5. Re: Need help with a new calculation with date fields
Kaz Shakir Mar 22, 2017 10:43 AM (in response to Kevin Stinnett)Kevin,
You said that you understand why you are getting nulls - can you explain that to us? And you said that you do not know how to make the formula work correctly - does working correctly mean that you would get rid of the nulls? or does it mean something else? It would be helpful if you could show us an image of the results you are currently getting, and a mocked-up image of what you expect the result to look like.
-
6. Re: Need help with a new calculation with date fields
Jamieson Christian Mar 22, 2017 11:10 AM (in response to Kevin Stinnett)Kevin,
It looks like the packaged workbook you posted still has a live connection to your data source, which means we can't review it.
For workbooks that connect to a database, you must first create an extract of the data, and then you can create the packaged workbook (it will embed the extract).
For more information, please see this help article: Packaged Workbooks (see section "Create a .twbx with non-file-based data sources")