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.