calculation query

[Coggnye]

Hi,

I have the following data with me :

Customer id customer funded balance customer unfunded balance customer account number & product code. Based on product code we decide whether the balance is funded or unfunded (bank issued lc, guarantee etc) for all unfunded product codes a certain is to be applied. No % is required on the funded balance portion.

i need an expression as thie. if product code = "000"then multiply the unfunded balance by 20% .

product codes :

111 = 2%
222= 0%
333 = 100%

i don't need to apply any % to the funded balance, it is to be considered as 100% as is. eg if funded balance is 400$ then it should stay 400$.

Please if someone could help me out with this one ?

[cognostechie]

Try to use comma and fullstop so that people can read and understand it properly.

You can create a calculated column with this kind of expression:

Case
    When [ProductCode] = '000' then [UnfundedBalance] * .2
    When [ProductCode] = '111' then [UnfundedBalance] * .02
    When [ProductCode] = '222' then  0
    When [ProductCode] = '333' then [UnfundedBalance]
    Else 0
End