LOOKUP formula conditional on time when time is NOT a line item

Options
Ashleigh_W
Ashleigh_W Member, ALL USERS Posts: 1 New Contributor
in Anaplan Community

I am working on creating a sales summary for 299 with time along my columns and see that the unit price of products changes over time, as such I would like to create a formula that selects price data dependent on the current time period, e.g., if it's currently January 2017, price of good A should be Z and if it's currently July 2017, price of good A should be W. I've looked into the time formulas to find what I am looking for but have come up empty. 

Tagged:

Comments

  • Ashishpandit
    Ashishpandit Member, ALL USERS, Partner, Certified Model Builder Posts: 3 Occasional Contributor
    Suppose if Price from Jan to May is X , June and July is Y and price from August to December is Z, here we can use the below logic -:
    IF ITEM(Time) >= TIME.'Aug 17' THEN 'Z' ELSE IF ITEM(Time) >= TIME.'Jun 17' AND ITEM(Time) < TIME.'Aug 17' THEN 'Y' ELSE 'X'

    Here no extra line item is required for time range

Categories