topic Re: L2 Sprint 3 INV01 formulas in Academy & Training https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102047#M2914

 

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!

Fri, 19 Mar 2021 00:31:35 GMT JaredDolich 2021-03-19T00:31:35Z L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/101937#M2910

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.

Thu, 18 Mar 2021 16:12:08 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/101937#M2910 Niraj.B 2021-03-18T16:12:08Z
Re: L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102045#M2912

 

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.

 

Fri, 19 Mar 2021 00:06:15 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102045#M2912 JaredDolich 2021-03-19T00:06:15Z
Re: L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102046#M2913

 Thank you, much appreciated. I have attached.

Fri, 19 Mar 2021 00:45:35 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102046#M2913 Niraj.B 2021-03-19T00:45:35Z
Re: L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102047#M2914

 

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!

Fri, 19 Mar 2021 00:31:35 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102047#M2914 JaredDolich 2021-03-19T00:31:35Z
Re: L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102048#M2915

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

Fri, 19 Mar 2021 00:37:58 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102048#M2915 Niraj.B 2021-03-19T00:37:58Z
Re: L2 Sprint 3 INV01 formulas https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102049#M2916

 

You got this!

Fri, 19 Mar 2021 00:39:47 GMT https://community.anaplan.com/t5/Academy-Training/L2-Sprint-3-INV01-formulas/m-p/102049#M2916 JaredDolich 2021-03-19T00:39:47Z