L2 Sprint 3 INV01 formulas

Hello,

I have finished writing up the formulas for all the line items, they also match the figures in next slide. How can I make sure that they are all correct (as there are multiple ways to write them)? Is there anyone in Anaplan I can email to verify? The reason I ask is few steps into the course I avoid a situation that it is suddenly not right.

Comments

JaredDolich

@Niraj.B

I completely understand. Here's a couple of suggestions:

Use the screenshots provided in the course to verify your numbers. If you're getting the right number you're formula is probably correct.
For formulas you want to double check or to see if you've got good syntax, post them on this Forum. I'm happy to check them for you.

Niraj.B

@JaredDolich Thank you, much appreciated. I have attached.

JaredDolich

@Niraj.B

Nicely handled! Looks great. Just two minor adjustments and one suggestion:

Reorder flag should be <=0, not <0. If your inventory gets to zero, you'll want to reorder, so go ahead and add the =
Shipping Method should be looking up "Supplied by" not the distribution center - I suspect you just renamed this which is okay. It's just a name change if you want.
Suggestion: for your conditional statements that use "IF-THEN-ELSE". Always try to put the most likely case at the front of the conditional so the calculation engine exits as quickly as possible. Helps performance.

Truly great work!

Niraj.B

Thank you so much ! I corrected the reorder flag, now it makes sense.

For the SYS08, not sure why I got as Distribution center. I will need to go in an earlier course to see if I made a mistake in setting up the module.

For the IF THEN, I had a look, I guess the only place I can change is 'PO Submitted' since most of times it will be 0 , all others seem seem ok unless I didn't catch

JaredDolich

@Niraj.B

You got this!

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…