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

HSDLee

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]

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!

HSDLee

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

BrunoRodriguez

Happy to help!