Reorder Flag INV01

Hello,

A question on the line item Reorder Flag? Do we need to end Future Ending Inventory line item to calculate Reorder Flag? I used the formula below but doesn't pull up the correct result, can anyone please suggest?

IF Ending Inventory < 0 THEN OFFSET(Shipping Time Weeks, 2, 0) ELSE 0

Thanks,

Comments

Misbah

@Sangya Close yet so far.

Explanation: Reorder Flag should check which weeks are hitting negative ending inventory so that system can reorder it automatically.

In your formula there are couple of mistakes

IF Ending Inventory < 0 THEN OFFSET(Shipping Time Weeks, 2, 0) ELSE 0

1. In OFFSET(Shipping Time Weeks, 2, 0) part you are hard coding it to number 2 - Wrong

2. In OFFSET(Shipping Time Weeks, 2, 0) part shipping time weeks again is the number - Wrong

3. Reorder Flag line item has to be boolean - Wrong

So your overall objective is never going to be met.

Hint:

1.Don't write IF ELSE statement

2. Overall Formula should be OFFSET(x,y,z) < 0 . Figure out what X,Y and Z can be based on the explanation given above

Hope that helps

Sangya_*23046

Thanks Misbah, made sense but still kind of figuring out. Here is what I used :

OFFSET(Shipping Time Weeks, -Ending Inventory, -1) and also in the instructions it says Re-order flag needs to be a Boolean..Any suggestions?

Abhiram K

Hi Sangya,

Understanding is ; The requirement is to flag the reorder line item as true when the ending inventory becomes negative.

W.r.t @Misbah has mentioned above "OFFSET(x,y,z) < 0", @Sangya There is one condition missed in your formula i.e. defining <, >,= ,etc "OPERATORS" for the boolean formatted lineitem to get the desired result.

x,y,z need to be figured out.

Try this, OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

Hope this helps.

~Abhi

Misbah

@abhi1017

It would have been great had you not shared the exact formula. I was kind of hoping he figure it out on his own. By sharing the formula it doesn't help them in any way.

Please Do Not Share the Formula.

Abhiram K

@Misbah

I just restructured the formula written by him with respect to the requirement stated, unaware whether its right or wrong.

I surely got your intent ,will follow it going ahead.

~Abhi

Misbah

@abhi1017

Thanks for understanding. Remember we are here to help others understand the logic. construct, syntax and the way of writing the formula and not to help them just pass the test.

Sangya_*23046

Thank You so much, not sure if this a test question but part of activity so I reached out to the community..

Abhiram K

@Sangya

Is the issue resolved now..?

Sangya_*23046

Yes and Thanks Again!!

Abhiram K

You are Welcome.could you mark my response as a solution for future reference?

Ptobar

Could you explain the reasoning for last part of the formula. I get the offset function but not why we need to end it with < 0?

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

MI1110

Thank you @abhi1017 and @Misbah for giving the clarity to be understood the formula, as always @einas.ibrahim said
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"

FYI @ Sangya

"As This Boolean-formatted line item is used to indicate if a reorder is needed to maintain an Ending Inventory value greater than zero. " so we need to offset ending inventory and every order has there own shipping weeks so we should not use hard coding for example number "2" rather than use "Shipping Time Weeks line" and put Z=0.

I hope this will help you to understand the context . as you already got the formula but we need to understand it for future occurances.

Thanks
Irfan.

omarismailcch1

abhi1017

Could you help me with the formula

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

why we added < 0 at the end , I got the first part with the formula but not sure about the < 0

Thank you

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…