How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?

I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory?

I tried the following and got errors:

Sales_Revenue[lookup: territory_id, lookup: PY ar_date]

Sales Revenue[sum: territory_id, sum: PY ar_date]

Accepted answers

BrunoRodriguez

Hello @zdlee ,

have you tried to convert the date into the period required for the module dimensioned with time?

You would just have to create a line item dimensioned by that time period and reference your date dimensioned line items using PERIOD() [https://help.anaplan.com/110a2a13-de1b-4274-82ee-c4ecd5e2dc90-PERIOD]

Please let us know if that does not resolve it.

Cheers!

All comments

BrunoRodriguez

Hello @zdlee ,

have you tried to convert the date into the period required for the module dimensioned with time?

Please let us know if that does not resolve it.

Cheers!

HSDLee

@BrunoRodriguez I got it to work using period. Thank you!

BrunoRodriguez

Happy to help!

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…