Period Function is not giving the desire output.

Hi Anaplaners ,

I am using the PERIOD function to populate the month from the date-formatted line item. In my case, it worked fine till FY26, but it is not returning anything after December 31, FY26.

My hunch is how Period works with model calendars?

Best Answer

  • Hi Araj,

    Indeed the period function will only retrieve and show periods that you have in your model calendar (time settings).

    Though, this works with time ranges as well. So if you need to display a specific time range as a result of a period or have a function that should calculate beyond the model calendar setting, you can manage that by using a time range.

    Hope this helps, Andris.

Answers