The values doesn't appear in Gridview

NadiaSafarah

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'

Gridview of 'Sales Qty - Motor'

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)

 

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'

Gridview of Module 'Sales Qty - Mobil'

Blueprint of Module 'Sales Qty - Truck'

Gridview of Module 'Sales Qty - Truck'

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?

 

ankit_cheeni

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.