Formula in BEx
How do I do the following formula in Bex?
Key figure: Sales to target = 75%
Key figure: Retail Sales = R250.00
If 'Sales to target' is =<100% then mulltiply 'Retail Sales' with 2.35%.
I just do not get it the same as in Excel.
Thanks yet again.
(Sales to Target =< 100) * Retail Sales * 2.35 / 100