How to group values of a column

building reports webintelligence
1

I have webi report with columns Employeecountry. If the country is in US, UK then it should group like NAmerica else if the country in IN,BD it should be INDIA
How to use If statement to compare column values in Inforview

sushmitha (BOB member since 2007-05-31)

2

Are you after something like this?

=If(Country InList ("US";"UK");"NAmerica";If(Country InList ("IN";"BN");"India"))

There may be syntax error. (as I don’t have the application opened right now)

Jansi :india: (BOB member since 2008-05-12)

3

You can create a variable:

=If([EmpCountry] InList ('US';'UK');"NAmerica";If([Empcountry] InList ('IN';'BD');"India"))

After that you can apply section on this variable.

aniketp :uk: (BOB member since 2007-10-05)

4

Yes. Its working. I was using only IN operator which is throwing me error.
Could you also let me know on how to get previous months data if we enter today’s date

sushmitha (BOB member since 2007-05-31)

5

If you are entering today’s date as “TILL DATE”, then you can use, Previous([Object]).

aniketp :uk: (BOB member since 2007-10-05)

6

I need to display in another column as count from the last month
Also one more column as count from this month’s beginning till date

how to do it in infoview. I need to do it only at report level

sushmitha (BOB member since 2007-05-31)