Based on the formula you provided, it seems that you are trying to calculate the "Confirmed Purchase Order Receipt" for the INV01 Module. However, there appears to be an issue with the formula logic.
The formula uses an IF statement to check if the "Confirmed PO Delivery" is greater than zero. If that condition is met, it uses the OFFSET function to retrieve the "Final Shipment Amount" value with an offset of "-Final Shipping Time Weeks" rows above the current cell. Otherwise, it returns 0.
The problem may lie in the usage of the OFFSET function. It is essential Clarks Customer Survey to ensure that the referenced cells and ranges are correct. Check if "Final Shipment Amount" and "Final Shipping Time Weeks" are accurately defined ranges or cell references in the worksheet.
Furthermore, verify if the units of "Final Shipping Time Weeks" align with the requirements of the OFFSET function, as it requires a numeric value for the row offset.
To troubleshoot the formula, cross-check the cell references, make sure the data types are compatible, and validate the logic against the intended calculation. By thoroughly reviewing and testing the formula, you should be able to identify and rectify the issue, helping you to achieve your certification goal. Good luck!
@berthaperez1148
I think you should be applying IF Confirmed PO Delivery <> 0 THEN……….
<> is not equal to sign,
Hope it helps 😊
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
