Hello Webi experts,
I a new to the webi reporting and trying to calulate a Formula variable.
I have a diemsion called Promotion Type which has several promotion types listed under it and some promotions are Direct promotiopns and some are Indirect promotions. I am trying to create a seperate calculations as seperate columns for Direct promotion and Indirect promotion., please take a look at my promotion dimension as a screen shot
Can you please advise me the correct syntax for Formula variable in the webi report to seperately calulate the Direct promotion and Indirect promotion.
I would really appreciate and assign full points.
Regards and Thankful in advance.