Alert Monitoring

Hello Everyone,

I've setup a weekly scenario tool that shows your starting and ending weekly inventory with the line items being the key factors like Forecast, Sales Orders, Purchase Orders, Planned Orders, etc... I export this data from SAP. I'm basically trying to recreate the planning book because our company doesn't really need it.

However, I have been told to recreate the Alert Monitoring functions in SAP. One of the basic calculations I've done is Weeks of Inventory On Hand. Anytime it gets below 1 weeks I have a Boolean. What I want to do is have a formula that essentially says if TRUE display the week starting date. The problem is IF statements can't display dates as an output.

This isn't an issue in excel so I'm confused as to why it is here.

Accepted answers

JaredDolich

here's a mock up for you. My calendar is in months so I added the number of weeks per month.

If you use weeks you won't need to do that.

Results:

Blueprint

All comments

JaredDolich

jedge@dsi.com

You might make sure that the line item is formatted as Boolean if you want the result to be TRUE or FALSE.

The formula will look something like this (remember, any time you use an IF statement you want to try to exit as soon as possible). Alternatively, you can try to use AND/OR with the same mentality.

IF [WEEKS OF SUPPLY] > 1 THEN FALSE else TRUE

Where WEEKS OF SUPPLY is your calculation.

If you want the result to be a date, then format the line item as date or period depending on what you want.

IF [WEEKS OF SUPPLY] > 1 THEN BLANK else [Date or Period]

jedge@dsi.com

Yeah like I said IF functions don't accept dates as outputs

Datatypes do not match for 'IF' function: DATE, NUMBER

JaredDolich

here's a mock up for you. My calendar is in months so I added the number of weeks per month.

If you use weeks you won't need to do that.

Results:

Blueprint

jedge@dsi.com

You are my hero, I guess adding FALSE was what I was missing

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…