IF Else at Bex Query
My requirement is to Calculate Formula for Net Sales in Bex Query.
If Incoterms = 'DDP'
Net sales = Gross Sales-(Freight DDP-Freight Discounts)
Net Sales = Gross Sales
For this what i did is,
1)Created Calculated CKF_1 and Passed Value '0'(Zero)( dummy ckf)
2)Created RKF_1 and restricted above CKF_1 with Incoterms = DDP
In formula pane written as like below
RKF_1 * (Gross Sales - (Freight DDP- Freight Discounts)) + Gross Sales
But i am not able to fetch the value when freight = DDP
Please let me know how can i acheive the Value.
Pls do the needful.