Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to determine why my subtraction is not working.
I've tried applymap and join and both achieve odd result.
I've tried num(field,format) and money(field,format) to the same odd result.
image is return/result. sending it to excel the numbers do appear as numbers and of course subtract to zero...had to put Num() to do so but would have only had to do it on the esc field if that is a hint as to the problem?.
I have tested the sources and their is a unique record in each set so it isn't a one to many issue either.
To further it if I subract the two in an expression...for this example I get 0 which is diff than Diffx which is the same formula...
however on other examples I don't get 0...so I am perplexed to say the least.
cts:
load
source,
MemID,
MemID & '\' & MemLoc & '\' & InvNo as MemMemInv,
MemLoc,
MemCust as MemCust,
InvNo,
InvDate,
NetNoCore as cts
FROM
(qvd)
where InvNo = '01JE9482'
;
join(cts)
esc:
load
//source,
MemID & '\' & MemLoc & '\' & InvNo as MemMemInv,
//MemLoc,
MemCust as escMemCust,
//InvNo,
InvDate as escInvDate,
NetNoCore as esc
FROM
(qvd)
where InvNo = '01JE9482'
;
STORE cts into r:\FromQV\ctsA&J.qvd;
drop table cts;
cts:
LOAD MemMemInv,
source,
MemID,
MemLoc,
MemCust,
InvNo,
InvDate,
num(cts) as cts,
escMemMemInv,
escMemCust,
escInvDate,
num(esc) as esc,
num(cts)-num(esc) as Diffx
FROM
(qvd);
exit Script;
Accepted Solutions
