Add formula to a Has Data? Line item

Options
Ajaykumartm1
Ajaykumartm1 Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

Hello,

 

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.

Ajaykumartm1_0-1613162452907.png

 

Tagged:

Comments

  • Ajaykumartm1
    Ajaykumartm1 Member, ALL USERS Posts: 4 New Contributor

    I have followed the process in the link you provided. But its not working. That's I posted the question here.

  • Ajaykumartm1
    Ajaykumartm1 Member, ALL USERS Posts: 4 New Contributor

    Hi,

     

    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!!

  • PaigeYM
    PaigeYM Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Occasional Contributor

    @rob_marshall thank you for your comment! I had the correct formula but had my time set to week/FY19. I'll remember that for next time 🙂 @JaredDolich , I totally agree! Anapedia is awesome 📚

  • rushabh41295
    rushabh41295 Member, ALL USERS, Partner, Community Member Posts: 1 New Contributor

    Hello Jared,

    You describe all the points where I'm facing error.

    After reading your comment, I understand all point properly.

    Thank You so much for help.

Categories