Level 2 - Sprint 1 (User Story 3) - Time Range related

The historic volume for FY19 was imported as below.

and the following SYS13 Account SKU Filter system Module was created.

I then tested further with by changing the Time Scale to Week.

and got the following results (changed the pivoting to reflect the below format)

I am intrigue with the results above as we only loaded Historic Volume for FY19 under Time Range. What is the reason for various weeks under FY20 'tick-marked'?

Comments

Akhtar.shahbaz

Hi @Star

You have Created "SYS13 Account SKU filter" module to filter out the Volume which is greater than 0 by using Timesum function, so it will filter all combination for all period which having values greater than 0.

It doesn't make sense as well if you have added the weekly Time scale.

It is same as the original module only difference is you have boolean formatted line item instead of number
You can't apply filter if you have time scale because it will be limited to week or year only not dynamic in nature

Hope this helps!

Thanks

Akhtar

Misbah

@Star

TIMESUM should be used only when you have a timescale in the source and None in the TARGET Module. You define what all parameters do you need while using TIMESUM

For example

TIMESUM(X) - It will aggregate the values for all periods in the source and bring you one consolidated value into target

TIMESUM(-2,X,2) - It brings value for 5 periods (i.e, 2 in the past, one current and 2 in the future ) from source module and consolidate them into one value into target. Here Current period of the Model plays a vital role

For more information please go through TIMESUM on Anapedia.

Hope that helps

Misbah

ThiruT

Hi Misbah

I am in SYS13 Account SKU Filter module and trying to fix the timesum formula. As I do not have much experience with fixing formulas I think I am doing it wrong. I am not sure whether the parenthesis is in the right place. I have provided the screen shot. Help is much appreciated.

Regards

Thiru Screenshot (166).png

Misbah

@ThiruT

Syntax is wrong. Use below formula and make sure it is boolean formatted line item

ThiruT

Thank you again. Because I don't have much excel expertise is there any website I can go to get some basic formula skills

Regards

Thiru

asnadeem

Hi Misbah,
I was wondering if the same results can be achieved by using all periods formula you discussed in other thread 1.01-04 Consider All Periods .
If yes then for the line item Time.All periods? what should be the syntax.

Regards,

Aslam

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…