How to change e.g. only one cell in table based on a structure

[Former Member]

Hello alltogether,

I do have another issue.

I've got a table which is based on a structure already implemented via query designer (Jan, Feb, ...., Dec).

Is it possible, even it doesn't make sense in the following example, to change the Cell Input as follows:

Example:

Before:     Jan   Feb   Mar   ...   Dec

After:       Jan   Jan   Mar   ...   Dec

Thanks a lot for your feedback,

[Former Member]

Hi,

As per my assumption of your problem, below formula will be useful,

=If([month]= "Current_month") Then "Curr" Else Left([month];3)

Thanks & Regards,

Ragoth.C

[Former Member]

OK and sorry.

Of course it is WebI and the version is 4.0.

I want to include a structure which comes from BEx query in a table.

Sometimes the character strings are to long. JAN, FEB e.g. is ok (only 3 chars)...But if it is "Curr. month"...the string is to long. I want to only "Curr." in that cell to appear. If I write it in the formula, all cells of the structure of course change to "Curr."

[Former Member]

Hi,

  Still you can use the same formula which i replied for your previous post, if you want to display certian number of char, try to use Left or Right function to acheive your goal.

Eg:

=Left([Cal. Month];3)

Thanks.

[Former Member]

HI,

     select the column in which u want to make the change. go to edit formula and use the function "left".

For example, if the cell contains "january"

in formula write as:

                                        =left(month;3)

the cell will display first 3 letters of the january i.e jan.

Hope this helps.

[Former Member]

Hi,

Yes We can change the cell within a table.

Jema could you explain it little bit clear.So that i can give a proper solution for you..

[Former Member]

Hi Jema,

       Can you please bit elobrate the issue? Also please include the info abt your reporting tool and its version?

Thanks.