Different Time Scale problem

KubotaNatsuki
Frequent 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

@KubotaNatsuki 

Yes you can! Leverage one of these functions

HALFYEARVALUE, LOOKUP

 

Misbah

KubotaNatsuki
Frequent Contributor

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

@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?

Regards, Kirill Kuznetsov
Planingo, LLC
ChrisAHeathcote
Community Boss

@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
HeathcoteAndHerran.com