Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

IF Else at Bex Query

Hi All,

My requirement is to Calculate Formula for Net Sales in Bex Query.

If Incoterms = 'DDP'

Net sales = Gross Sales-(Freight DDP-Freight Discounts)

Else

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

3)CKF

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.

Thanks.

Regards,

Seshu

Former Member
Not what you were looking for? View more on this topic or Ask a question