Filter inquiry

hi Community,

I just got this requirement recently and it is giving me quite a challenge. the requirement is to select the current month then display the 3 prior months and Current month on the table. So example, user will select Jan 23 then the table should display Jan 23 Dec 22 Nov 22 and Oct 22.

so far this is what I have a module where I assume I would be doing an ITEM(TIME) to capture the current month.

I can't seem to capture the current month and the previous 3 months on the boolean line.

Any ideas will be much appreciated.

Regards,

Accepted answers

All comments

BrunoRodriguez

Hello @Jsdeloria21 ,

Please find below an option to resolve your issue:

I hope that helped!

Jsdeloria21

hi Bruno Rodriguez,

Thanks for your help.

Regards,

Jsdeloria21

hi Bruno,

Why is APr20 checked again? Was it the current month set? Thanks just trying to understand further the formula.

Regards,

BrunoRodriguez

Hello @Jsdeloria21,

My understanding was that you wanted the current month + the 3 previous months. Hence, July (current) + June, May, April.

If you want to modify the tail of months, change the -3, as it is driving that.

Cheers!

Jsdeloria21

hi BrunoRodriguez,

Thank you I was able to make it work. Appreciate the insight given

Regards,

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…
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…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…