Level 2 Sprint 1 - 1.5.7.2 Add Formula to SYS13 Line Item

Options
sdemel
sdemel Member, ALL USERS, GroupMember Posts: 2 New Contributor
in Planning & Modeling

Hi,

 

Can I please get some help with the formula for this?

 

Thanks

Tagged:

Comments

  • sdemel
    sdemel Member, ALL USERS, GroupMember Posts: 2 New Contributor
    Thanks very much.
  • anujtohani
    anujtohani Member, ALL USERS Posts: 2 New Contributor

    Hi, can anybody please help with this query?

    What formula is to be used?

  • vishwajeetg
    vishwajeetg Member, ALL USERS Posts: 1 New Contributor
    IF TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 THEN TRUE ELSE FALSE
  • swapnil_J
    swapnil_J Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Frequent Contributor

    Hi @jasonfortunato 

    Both syntax are correct.

    In first you are asking anaplan to sum up the values across the time period of the module and then to check where the sum is not equals to zero.

    TIMESUM('DAT03 Historic Volumes'.Volumes) <> 0 

    In below syntax you are using three more arguments(start period,end period and aggregation method) along with Number line items. In current scenario it is not required to have these 3 arguments.

    TIMESUM(TIMESUM line items.Number, 0, 4, SUM)

     

  • micahma
    micahma Member, ALL USERS Posts: 2 New Contributor
    I think it asked about all period, for dat03, isnt it only has fy19 data?

Categories