Skip to Content
author's profile photo Former Member
Former Member

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

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2012 at 09:35 AM

    Hi Jema,

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

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2012 at 09:39 AM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2012 at 09:53 AM

    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."

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2012 at 10:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.