Calculating Discount

[bharatkishore]

Hello All,

                   I have an discount fields of 6 types Such as LD1,LD2,LD3,LD4,LD5,LD6.I have done all of them sum to get the total discount.Now i want to get only individiual discount.

                   And also i want to get all of the fields discount.Can any one help me.

Regards,

R.Bharat Kishore

[vijay_iitkgp]

Hi Bharat,

If I understand your question correctly. you can use if condition to create different fields.

If(Discount Type='LD1',DiscountAmount) AS LD1 and so on...

Hope this will help

[bharatkishore]

Hi Vijay,

                     Thanks a lot for the reply.But i already have six fields.I just want to get discount for each if them.Can you help me what expression i need to write.

[vijay_iitkgp]

then you can use Sales*LD1 as LD1Discount....