Formula's in Script

[Carlaf_93]

Good morning,

i have a table like this:

[TABLE1]:

load

YEAR,

MONTH,

CODE,

CATEGORY,

VALUE

FROM [];

i would like to create a new measure that when -->

CODE= 'WWW1','WWW2', 'WWW3'    AND     CATEGORY = 'AA0'

it gives me a Value like---> Value * 0.8  as VALUE and for all the others value it gives the original field VALUE

Thanks