CURRENTPERIODEND() does not work

Hi everyone,

I was having trouble when I start learning working on a module with switchover. I set the switchover on and set the month.

It started okay, until I want to get the data from the beginning until the end of the period. I used CURRENTPERIODEND() function. But when I check out the output it turns out empty. I expect that it will shows the end date just before the switchover started.

Did I miss something?

Thanks for your help

Accepted answers

ManjunathKN

Hi @deantari

Did you provide the current period in time settings?

if left blank there, you will get blank in currentperiodend() formula.

Thanks,
Manjunath

All comments

ManjunathKN

Hi @deantari

Did you provide the current period in time settings?

if left blank there, you will get blank in currentperiodend() formula.

Thanks,
Manjunath

MarkWarren

You need to have a Current Period set in Calendar for CURRENTPERIODEND

deantari

Hi @ManjunathKN

oh no, I left it empty in time setting.
what should I pick as the current period over there?

ManjunathKN

you need to pick your current planning month.

Thanks,
Manjunath

deantari

Hi @MarkWarren
you're right, I left the current period empty as I don't really get it before.

Thank you

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…