OFFSET on LIST ITEM

Options
Unicorn
Unicorn Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

When entering the formulae below it works,however if i change the -1 in the OFFSET formulae to point to a lineitem to pass the no of periods to offset it is formatted as a number anaplan gives an error , the AutopopulateActivity line item is fomatted as a list item.

IF ISNOTBLANK(Select Job Code) THEN Select Job Code ELSE OFFSET(AutoPopulateActivity, -1, BLANK)

 

 

 

error.JPG

Tagged:

Comments

  • Unicorn
    Unicorn Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    have a timescale set to Day

    want to be able to set a pattern in the first 56 periods, then to copy the first 56 periods to the next 56 periods

Categories