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?