Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have the following script , the subtraction in the end giving no results , i've added a picture of no result
What am i doing wrong?
INVENTORYCDP1:
LOAD PARTNAME AS [PartIDPriorityCDP] ,
PARTDES AS [PartNamePriorityCDP],
COST AS [COSTPriorityCDP],
WARHSNAME AS [WARHSNAMEPriorityCDP],
INVENTORYLEVEL AS [INVENTORYLEVELPriorityCDP],
UNIT AS [UNITPriorityCDP],
TOTALCOST AS [TOTALCOSTPriorityCDP]
FROM
[..\..\1_resources\1_Raw\INVENTORYCDP.QVD]
(qvd);
LEFT JOIN
LOAD PARTID AS [PartIDPriorityCDP],
LOCATIONID AS [WARHSNAMEPriorityCDP],
Num(ONHAND, '0') as ONHAND ,
RepairCenterName
FROM
[..\..\1_resources\1_Raw\INVENTORYLEVELCMMS.QVD]
(qvd);
STORE INVENTORYCDP1 INTO [..\..\1_resources\1_Raw\INVENTORYCDP1.QVD];
DROP Tables INVENTORYCDP1;
Directory;
LOAD PartIDPriorityCDP AS [PartIDPriorityCDP1] ,
WARHSNAMEPriorityCDP AS [WARHSNAMEPriorityCDP1],
PartNamePriorityCDP AS [PartNamePriorityCDP1],
COSTPriorityCDP AS [COSTPriorityCDP1],
INVENTORYLEVELPriorityCDP AS [INVENTORYLEVELPriorityCDP1] ,
UNITPriorityCDP AS [UNITPriorityCDP1],
TOTALCOSTPriorityCDP AS [TOTALCOSTPriorityCDP1] ,
ONHAND AS [ONHAND CMMS],
RepairCenterName AS [RepairCenterName1],
(INVENTORYLEVELPriorityCDP - ONHAND) as [DIFF BETWEEN SYSTEMS]
FROM
[..\..\1_resources\1_Raw\INVENTORYCDP1.QVD]
(qvd);
Have you tried to convert the two fields to numeric values before performing the subtraction?
Have you tried to convert the two fields to numeric values before performing the subtraction?
May be scroll to the right and see, If values are coming as Zero?
Hi ,
Tried to put
Num(Field) and tried Num#(Field) - none worked.
Nothing comes.