3.3.5.3 Check Your Work Level 2 Sprint 3

Hi everyone,

I'm checking my work of my INV01 module and my numbers are slightly different in the line item Safety Stock Exception Count to the ones provided by Anaplan to check our work. I already checked the summaries and the totals and they look fine, I would really appreciate some help.

My INV01 module below, you can see the change from week 3 FY20

Anaplan example below

These are the formulas i used

Thank you very much in advance for your help

Comments

shashank30

Hey, as far as I know the formula which you have entered for safety stock exception count needs to be changed. It's partially correct.

Re-check the operators which you have used.

Regards,

Shashank

jairamkamath

@DanielaSanchez I think you wrote the calculation other way round and missing by few values.
Often the IF conditions get tricky. Can you please try below.
IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

MCRaws65

Is there any reason why...

IF Safety Stock Target >= Ending Inventory THEN 0 ELSE 1

...would be incorrect?

Apparently it is wrong, but I can't see why.

I framed it that way round (and it works in my model) because we were told to frame IF statements so that the most common result comes first and Anaplan gets to skip looking at the ELSE statement.

jairamkamath

The question raised above does not have the "=" and that's where it becomes incorrect.

@MCRaws65 The calc should work fine with formula you posted.

MCRaws65

Thanks Jairam, it does work fine, but is apparently "Incorrect"! 🤔

ChrisAHeathcote

@DanielaSanchez

Check the summary settings.

Quick Links

Recent release news

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…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…