Hello there,
My Material table has MaterialName and YearlyImportableLimit fields and Import query has MaterialName and ImportedQty fields. I made a query where I deduct ImportedQty from YearlyImportableLimit and the balance is my RemainingImportLimit. But the problem is that not all the material has ImportedQty value. Because some of the materials has not yet imported at all. Hence when I do the deduction, RemainingImportLimit field shows result for only those materials that has value in the ImportedQty field and the rest of the rows remains blank. Whereas those blank rows should have shown the full vlaue for YearlyImportableLimit as there was no deduction.
Any help please?