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.