if variables in webi

building reports webintelligence
1

I have a column that has numeric values like 10 and 20. I want to create a variable that says when the value is 10, present it as “Actuals” in text.
When 20, present “Plan” in text…
And so on.

Any examples of this?

segerton (BOB member since 2009-05-21)

2

Hi:

Yes - IF clause is available in WebI. When you create the variable, use the IF clause for this.

If (<field> = 10; "value"; if <field> = 20; "value"; if <field> = 30; "value" ...etc

Check out the help for the IF statement… you will find more samples.

Regards
Ramesh Vasudevan

rameshbalajiv (BOB member since 2008-03-25)

3

Hi,
Try…

=if ([Measure] = 10 ; "Actuals"; if ([Measure] = 20 ; "Plan" ; "Other"))

Jamesr60 :uk: (BOB member since 2009-07-14)

4

You can also use Alerters if you dont want creating variables, but it really depends on your requirements

Regards,

jvmauricio :philippines: (BOB member since 2009-08-03)

5

Thanks all, I’ll give this a try. I appreciate the quick response.

segerton (BOB member since 2009-05-21)