Level 2 Sprint 3 3.3.6

Fina · 2023-09-02T07:55:34+00:00

There was an error rendering this rich post.

Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items.

The formula I used for both:

Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

Final Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

But it resulted in zero on both, not sure where I went wrong

Accepted answers

schordia

Hi Fina,
I would need more information about the specific issues or errors you are encountering to suggest a solution. However, here are a few general suggestions:

Check the data sources: Ensure that the data in the 'tra01 shipping metrics by week' and 'sys08 sku details' tables are accurate and up to date. Double-check the lookup values to make sure they match the corresponding columns in the tables.
Verify the formula syntax: Make sure the formula syntax is correct, including the use of brackets, quotation marks, and lookup functions. Check for any missing or extra characters that may be causing errors.
Debug the formula step by step: Break down the formula into smaller parts and test each part individually. This will help identify any specific issues or errors in the formula.

I have used the same formulas, and the function is returning the correct values.

All comments

schordia

Hi Fina,
I would need more information about the specific issues or errors you are encountering to suggest a solution. However, here are a few general suggestions:

Check the data sources: Ensure that the data in the 'tra01 shipping metrics by week' and 'sys08 sku details' tables are accurate and up to date. Double-check the lookup values to make sure they match the corresponding columns in the tables.
Verify the formula syntax: Make sure the formula syntax is correct, including the use of brackets, quotation marks, and lookup functions. Check for any missing or extra characters that may be causing errors.
Debug the formula step by step: Break down the formula into smaller parts and test each part individually. This will help identify any specific issues or errors in the formula.

I have used the same formulas, and the function is returning the correct values.

Fina

Hi, turns out I didn't add the formula for Cost per 1000 Units line item in TRA01 Shipping Metrics module, after I updated the formula it works and returns the correct value now.

Thank you!

Fina

Hi schordia,

I actually have another question regarding filter in the custom view on UX page

I tried to put filter for Planning Period Filter from SYS01, but if I put the filter condition to is true, it became like this (see attached with condition: is true), but if I put is false as the condition, it shows.

schordia

Hello @Fina,

I hope this message finds you well. I would like you to review the formula utilized for the planning period filter in the Sys01 time settings by week. It is imperative that the formula accurately calculates the month value of the planning period filter, as derived from the time settings by month.

Best regards,
Sambhav

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…