why thiserror is poping up again and again. Kindly assist.
Generally that meaning that the source module, in this case 'TRA01 Shipping Metrics by Week' has a dimension (applies to) which is within the same hierarchy as your target module. This error indicates that you have not provided a relevant criteria to bridge or lookup the value between levels.
Within the SYS08 module, look at the format of the "Product" line item, does it match to the dimension in the TRA01? The lookup formula is defining the relationship between the levels, so you must ensure you are selecting the relevant criteria to lookup that parent to child relationship.
Hope this helps to understand the issue and possible resolution.
Hi,
My formula firmulis okay but still this error is showing because Im using shipping method text in the formula which is okay.
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…