Christmas Brain Freeze or Summing from a module when you don't have time as a dimension

Hi,

I have a module (SER) with simple data for a PO, value and a year period by customer

In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date.

SER.Value[SUM: SER.Customer]

This gives me the total, but i only want the total for FY21 as it is an FY21 invoice. (i.e 150)

Its probably Christmas fog, but surely this is simple and i have a mental block?

Accepted answers

M.Kierepka

Ah sorry, just noticed that you are referring to the target module - on the screenshot it looks like it has time dimension. If it's subsidiary view or something, and you only want 2021, I see two options (I assume 2021 is labeled as "Previous Year", and should be defined as line item in SYS module):
1. In the SER module, add column "PY Customer" with formula "IF SER.Year=SYS.Previous Year THEN Customer ELSE BLANK. Then in your reporting KAM module just SUM using this new line item, so formula should be equal to: SER.Value[SUM: SER.PY Customer]
2. build calculation module in which you will SUM it by customer and period, then in you reporting module just LOOKUP by Previous Year

All comments

M.Kierepka

Hi,

Based on what I see on your screenshots, just adding SUM by Time to the formula should be enough. So your final formula should be:
SER.Value[SUM: SER.Customer, SUM: SER.Year]

If you'd have Time dimension in the source module, you would not need that, but because you don't have it, you need to explicitly point Anaplan to the line item from which it should take Year mapping.

EgeK

Hi DeveloperCYT,

Try TIMESUM(), since you want the sum of something dimensioned by time, but where your target module has no time.

You could refer to the start and end period on line items which either have formulas to automate what time range you want to see or have them as input fields so the end user can change it, giving them flexibility.

See Anapedia:

https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM

Hope this helps!

Ege

DeveloperCYT

But i don't have TIME in my invoice module, so that won't (and doesn't) work.

M.Kierepka

But you have Year column in SER module - the last column on your first screenshot. You can just Sum by it (I assumed in my formula it's just named "Year")

DeveloperCYT

Hi,

SER.Value[SUM: SER.Customer, SUM: SER.Year]
works if i have a timescale in the invoice module, BUT i do not have a timescale in the invoice module, that would indeed be simple as it would if i had a timescale in the source module.

M.Kierepka

DeveloperCYT

I have no timescale in either module, so cannot use timescale i think

DeveloperCYT

That would work, may slightly tweak but yes i like the idea

thanks

EgeK

Ah right sorry, I agree with M.Kierepka's suggestion above then ^^^

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…