Function Month on a date cube
Hi,
I need to calculate prepaid expenses.
By writing, I have:
- an "Amount" cube,
- a cube, in date format, "Start date",
- a cube, in date format, "End date".
I just need to retrieve, in a calculated field, the month of the "Start Date" cube.
So, I just tried month (b) and it does not work because it looks like the Date field is like a numeric field.
Answers
-
Hi Sébastien,
I believe the MONTH() functionality only works in NEXEL and not directly in your dataview layout.
.I am not 100% clear about how the dimensions of your cubes look like but I believe I have two potential options for you.
1) You can use the MONTH() functionality in NEXEL retrievable from functions:
2) You can use the left() functionality in the dataview to treat your data cube as text:I hope I was useful.
All the best,
Jonathan6
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 150 Academy
- 312 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 183 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 334 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP