Skip to Content
0
Former Member
Jan 18, 2008 at 09:05 AM

BEx Formula assistance required

11 Views

Good Morning

Please assist? In Excel the formula is:

""=IF('SUM Sales' > 'SUM Target',('SUM Target' *'% of Nat'),IF('SUM Sales' < 'SUM Target',('SUM Sales' *' % of Nat'))""

I have the key figures available in BEx, but I have difficulty creating the same in a formula in BEx.

Key figures in BEx:

(1) SUM Sales

(2) SUM Target

(3) % of National

How do I do it in Bex, not to get a Syntax error?

Assistance or guidance will be highly appreciated.

Thanks and have a nice weekend.

Cornelius Faurie