Period Function is not giving the desire output.

araj
araj
in Modeling

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?

image.png
image.png

Best Answer

  • Ingilavicus
    Ingilavicus
    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

Categories