If then Else statements

[former_member277624]

Hi

I am new to Business Objects. I am trying to construct a statement in Webi but I am having difficulty with the syntax.

In my report I have 2 particular columns: Rate of Pay and Grade Description.

I want a statement that will say something like: If the Grade Description returns Casual, then set the Rate of Pay to 0 otherwise use the rate of pay that is displayed.

Can anyone assist with how this should be written as a variable?

Many thanks

Will

[Former Member]

Hello Will,

Its as simple as you wrote your pseudo code and what Mahboob suggested.

= If [Grade Description]="Casual" Then 0 Else [Rate of Pay]

Like any other programming it would give you a sample to show how that has to be written in compatible to Webi. if you see attached screen shot you will notice that in a formula editor Webi has given you all the list of available function and Operators. If you click on any function it will show you how we can make use of it.

Hope this helps for your future reporting reference.

Regards

Niraj

[mhmohammed]

Hi Willl,

Create a variable with this formula, its pretty self explanatory.

=If([Grade Description]="Casual")  Then  0  Else ([Rate of Pay])

Try to go through a getting started guide of Web Intelligence and /or BI LaunchPad.

This is the Web Intelligence from BO 4.1 SP5:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp6_webi_user_guide_en.pdf

Also, check this out:

Thanks,

Mahboob Mohammed