The values doesn't appear in Gridview

NadiaSafarah
NadiaSafarah
in Modeling

I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different subsets from the same list for each module.

 

Blueprint of Module 'Sales Qty - Motor'

NadiaSafarah_0-1658509442665.png

Gridview of 'Sales Qty - Motor'

NadiaSafarah_2-1658509539954.png

I use a subset list (SS_Motor) from list 'VEHICLE' that had a property of another list 'VEHICLE CATEGORY' that I've grouped by their own product category (Mobil, Motor, Truck)

NadiaSafarah_4-1658509669131.png

NadiaSafarah_5-1658509915637.png

 

For two other modules (Sales Qty - Mobil and Sales Qty - Truck), I use other subsets from the same list (VEHICLE). I use SS_Mobil for module 'Sales Qty - Mobil' and I use SS_Truck for module 'Sales Qty - Truck'.

 

Blueprint of Module 'Sales Qty - Mobil'

NadiaSafarah_6-1658510623469.png

Gridview of Module 'Sales Qty - Mobil'

NadiaSafarah_7-1658510738661.png

Blueprint of Module 'Sales Qty - Truck'

NadiaSafarah_8-1658510788861.png

Gridview of Module 'Sales Qty - Truck'

NadiaSafarah_9-1658510838546.png

The results of the formula/calculation doesn't appear even though I use the same exact formula for these modules. Why is this happened? I guess It might happened due to the subsets that I use for each modules come from the same list, but I'm not so sure. How do I fix this? what should I do to make all the value appear successfully in every modules without changing the the subsets or modified the list?

 

Tagged:

Best Answer

  • ankit_cheeni
    ankit_cheeni
    Answer ✓

    Hi @NadiaSafarah 

     

    This is what I was expecting. The issue here is that your Allocation Quantity module is dimensioned by a subset instead of the whole list. For Motors, you have Percentage values present in Allocation Quantity but you do not have the values present for Mobil and Trucks in your Allocation Quantity module. 

     

    My understanding is Allocation Quantity (and TargetQty) should be dimensioned by the VEHICLE list instead of subsets. 

    Let me know if this makes sense. 

Comments

  • ankit_cheeni
    ankit_cheeni

    Hi @NadiaSafarah 

     

    Can you share the blueprint and values in Target Qty and Allocation Qty? Can you check if they have values for Mobil and Truck. 

  • JaredDolich
    JaredDolich

    @NadiaSafarah 

    Try creating a system module for the vehicle list. It's generally not a good idea to reference list properties. So in this case, you'll want to create SYS100 Vehicles. In that module create a line item that contains the "category". Then use LOOKUP on the line item. You can also create a line item that indicates which sublist it is in as well. In fact, you may just want to create a single list that contains the possible vehicles types, motor, mobil, truck. That way if more types are created you don't have to create another sublist.

  • NadiaSafarah
    NadiaSafarah

    sure, here are the blueprint and gridview of Allocation Qty, I use the values from line item 'Percentage' in both module 'Sales Qty - Mobil' and module 'Sales Qty - Truck', as well as module 'Sales Qty - Mobil' as an allocation value.

     

    Blueprint

    NadiaSafarah_0-1658547680625.png

    Gridview

    NadiaSafarah_1-1658547717753.png

     

     

  • NadiaSafarah
    NadiaSafarah

    Problem solved, thank you. I don't even realize I only applied to SS_Motor in Allocation Qty lol

Categories