Dear Seiors.
We want to update the 2 columns with if conditions below is the result table.
<table><tbody><tr><td style="height:14.4pt;width:85pt;">PREVIOUS_STOCK</td><td style="border-left-style:none;width:62pt;">NEW_STOCK</td><td style="border-left-style:none;width:48pt;">QTY_OUT</td><td style="border-left-style:none;width:41pt;">QTY_IN</td></tr><tr><td style="border-top-style:none;height:14.4pt;">0</td><td style="border-left-style:none;border-top-style:none;">5</td><td style="border-left-style:none;border-top-style:none;"> </td><td style="border-left-style:none;border-top-style:none;">5</td></tr><tr><td style="border-top-style:none;height:14.4pt;">5</td><td style="border-left-style:none;border-top-style:none;">4</td><td style="border-left-style:none;border-top-style:none;">1</td><td style="border-left-style:none;border-top-style:none;"> </td></tr><tr><td style="border-top-style:none;height:14.4pt;">4</td><td style="border-left-style:none;border-top-style:none;">-2</td><td style="border-left-style:none;border-top-style:none;">6</td><td style="border-left-style:none;border-top-style:none;"> </td></tr><tr><td style="border-top-style:none;height:14.4pt;">-2</td><td style="border-left-style:none;border-top-style:none;">10</td><td style="border-left-style:none;border-top-style:none;"> </td><td style="border-left-style:none;border-top-style:none;">12</td></tr></tbody></table>
IF THE PREVIOUS_STOCK IS LESS THEN NEW_STOCK THEN UPDATE QTY_IN COLUMN
ELSIF PREVIOUS_STOCK IS GREATER THEN NEW_STOCK THEN UPDATE QTY_OUT COLUMN
Please help, thanks.