nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trying to look up a LI for the previous 6 month average

neg177

Hi,

I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below.

Thank you

Accepted answers

ankit_cheeni

I think your time is opposite. It should be C-6 and then C, C being current period

All comments

ryan_kohn

Hard to tell without seeing the dimensions/structure of the source module as well as the dimensions of the module you've shared. Can you post blueprints of both?

Also, something to note about the TIMESUM function arguments, though I'm not sure if it's relevant here:

If you use a date value for either the Start period or End period argument, their positions are swapped. This means that the End period argument should be a date in the period when aggregation begins and Start period should a the date in the period when aggregation ends.

neg177

This is the Blue Print of the module the formula is being performed

Here is a Blueprint of the source module

Here is a Blue Print of the SYS module we are using for the TIMESUM

Thank you

ankit_cheeni

I think your time is opposite. It should be C-6 and then C, C being current period

neg177

Hi,

That did get numbers to show.

Thank you

Quick Links

Can you help?

Unanswered questions

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…