I'm trying to use the following statement:
IF (IDS2_TXT.FIRST_MODIFIER="HQ" THEN
(IDS2_TXT.UNITS/240))
But an error appears whn i try to run it. Basically i want sql to only divide the amount of unit of a record if it finds a value on one of the fields (an leave the rest like they are) can someone please help me on what is wrong with the statement. Thank you.
using the derived column transformation:
FIRST_MODIFIER=="HQ"?(UNITS/240):UNITS
Frank
No comments:
Post a Comment