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 ?
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