Can I use Lookup Formula in this case ?

SAtrane
SAtrane
in Modeling

Hello all,

I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source". Could you please assist me? I've attached a screenshot for reference.

Target model : Forecast of products W : dimension(Product list, Time Week)

Source model : Forcecast of all product : dimension(Product list, Time Week)

Maping : Product type

Product type is a line item

image.png
image.png
image.png


Error messages :

image.png
cas 1.png


Answers

  • Misbah
    Misbah

    You need to use SUM instead LOOKUP. But before you use SUM you don't need to have Product List as a dimension in your target module, change it to Product Type.

    Formula should look like this in your target module

    CAL 02 Forecast per week. Prevision per week methode 2[SUM: SYS 04. Product Type]

    Hope that helps, @SAtrane

    Misbah

    Miz Logix

Categories