Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

Hello everyone,

I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this?

FORMULA:

IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

Thank you.

Error_98428.png

Accepted answers

JaredDolich

@ismaelmaclovio

Your formula is exactly correct. So take a look at SYS01 and make sure the line item is there and spelled the same way and has the following formula.

'NOT First Week of Timescale?' = NOT First Week of Timescale?

All comments

JaredDolich

@ismaelmaclovio

Your formula is exactly correct. So take a look at SYS01 and make sure the line item is there and spelled the same way and has the following formula.

'NOT First Week of Timescale?' = NOT First Week of Timescale?

ismaelmaclovio

@JaredDolich
Thank you once again. I realized that I was missing 2 line items so I added them and inserted the formula and it worked.

mohsensami

@ismaelmaclovio

I have the same problem, how did you add two lines items and what are those line items?

Can you help me, about that?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…