I am new to Anaplan platform. Now I am working on Level 2 model building training. Here I have an issue to write a formula to line item. I don't have any kind of data in SYS13 Account Filter Module. I have data in DAT03 Historic Volumes Module. In DAT03 Module I have only one line item Volumes and I don't have any List items which are rolled-up to their parent. All the lists are flat lists only. Here how can I write a formula to check particular item has data or not.
Great question. This is part of the L2 certification to test your ability to use Anapedia (for a hint on this problem, click this link).
It's best to get familiar with Anapedia. Even the best of the best Master Anaplanners come back to Anapedia.
Give it click. See if that points you in the right direction.
Also, use the search feature in Anaplan Community. You'll find that someone has probably asked the same question. Nothing wrong with seeing how others solved the problem, as long as it helps you get the right answer!
I can able to write formula by using MONTHVALUE() function for my issue. This is ok now for my requirement. But I have another query here. I got the values from source to target by using MONTHVALUE() function, My source has Month's as a time scale and target has Week Time Scale (4-4-5). If I transfer data same month value is loaded for all the weeks in target.
For example: I have 4 as a value for January month in source module, When I transferred data to target, I have the values like Week1 (4), Week2 (4), Week3 (4), Week4 (4). I don't want values like this, I want the values to be segregated when it comes to target like, In my target January month has 4 weeks if I transfer the value it should split value of 1 for each week and the total value of Jan is 4. But now 4 value is added to each week and my consolidation value of Jan is 16.
How can we segregate the values from months to week. I searched in google and I am getting only functions to aggregate the value not for segregation.
Can you please help me on this. !!Thanks in Advance!!
If you are going to use timesum(), make sure the line item with the timesum formula does not have Time applied to it. In this instance, you will be creating a subsidiary view, but this is better for performance purposes.