Different Time Scale problem

KubotaNatsuki
Contributor

Different Time Scale problem

hi!

 

I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month.
Can i do it?
Please help me.

4 REPLIES 4
Misbah
Moderator

Re: Different Time Scale problem

@KubotaNatsuki 

Yes you can! Leverage one of these functions

HALFYEARVALUE, LOOKUP

 

Misbah

KubotaNatsuki
Contributor

Re: Different Time Scale problem

Thanks for your reply!
I can do it!!
You've been so helpful!
KirillKuznetsov
Certified Master Anaplanner

Re: Different Time Scale problem

@KubotaNatsukiyes, you can do this!

Check out this article about HALFYEARVALUE:

https://help.anaplan.com/618b82cc-513b-4183-9122-23fc6590cabc

Might be helpful in your build.

As well you can make some different references via LOOKUP or some of aggregation functions: https://help.anaplan.com/909cff1d-4de2-498e-9d04-2fb9f7d71583-Aggregation-Functions 4

What is your case?

ChrisHeathcote
Community Boss

Re: Different Time Scale problem

@KubotaNatsuki 

Remember that using HALFYEARVALUE will allocate the value to all months in the target module. 

If you want to distribute this down to months you will need to phase the value across the 6 months based on a assumption. This could be flat by dividing the value by six or based on another driver such as sales activity.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA