sommererdbeere
Programmer
hi,
my question here is:
i want to replace a number to 0. in formular editior, i have my code written as
if (workcen = 'su' and SAP <> 0) then
qty = 0 and
issued = 0
else
workcen
from the above, i want to show every "SAP" that is not equal to 0 whenever workcen = 'su'. if this is valid, then, replace everything in qty and issued column to be 0. otherwise, return all workcen.
example
data before changes made:
work cen qty issued sap
su 0 3 0
su 30 4 15
su 20 5 0
hk 30 0 40
hk 30 2 0
after the changes:
work cen qty issued sap
su 30 0 0
su 20 5 0
hk 30 0 40
hk 30 2 0
i've been posting for a while, but i didn't get respond .. i really really need your help.. please help and be advice.. many many million thanks..
m
my question here is:
i want to replace a number to 0. in formular editior, i have my code written as
if (workcen = 'su' and SAP <> 0) then
qty = 0 and
issued = 0
else
workcen
from the above, i want to show every "SAP" that is not equal to 0 whenever workcen = 'su'. if this is valid, then, replace everything in qty and issued column to be 0. otherwise, return all workcen.
example
data before changes made:
work cen qty issued sap
su 0 3 0
su 30 4 15
su 20 5 0
hk 30 0 40
hk 30 2 0
after the changes:
work cen qty issued sap
su 30 0 0
su 20 5 0
hk 30 0 40
hk 30 2 0
i've been posting for a while, but i didn't get respond .. i really really need your help.. please help and be advice.. many many million thanks..
m