Level 2 Sprint 3.3.5.2 Confirm Purchase Order Receipt Line Item

Hi everyone, would really appreciate if anyone could help me with this problem. My formula is 'IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0'. Is this formula not correct? I have been trying several different formulas using my logic but cannot seem to get it right. Would really appreciate some help. Thanks.

Accepted answers

All comments

KUMARNR

Hi @AbhavPasricha the formula is correct, if you are using the single quote in start end of the formula, remove that just keep -

IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0

and hope this will help, and if you are getting any other error, please share the error for better understanding. Cheers!

AbhavPasricha

Hi @KUMAR NR thank you for your help, I figured it out

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…