The values doesn't appear in Gridview

NadiaSafarah
Occasional Contributor

The values doesn't appear in Gridview

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
ankit_cheeni
Super Contributor

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. 

View solution in original post

5 REPLIES 5
ankit_cheeni
Super Contributor

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. 

NadiaSafarah
Occasional Contributor

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

 

 

ankit_cheeni
Super Contributor

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. 

NadiaSafarah
Occasional Contributor

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

JaredDolich
Moderator

@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.


Jared Dolich