Hi,
I am trying to add row in pivot by calculating difference of two other rows of outstandingg Amount.
But i got incorrect value.please help me to figure out what is the issue or else some other method to calcullat it.
here is the snapshot of output and script.
diff:
Load
"SEGMENT CODE" as diffseg,
OS_Date ,
OS_Date as diffosdate,
"LOCATION NAME" as diffLocation,
"OUTSTANDING AMOUNT" as diffout
resident Out;
Concatenate
Load
"SEGMENT CODE" as diffseg,
OS_Date,
'Diff' as diffosdate ,
"LOCATION NAME" as diffLocation,
"OUTSTANDING AMOUNT"-Previous("OUTSTANDING AMOUNT") as diffout
Resident Out ;
