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

Formula Report Painter

Hi,

I have a formula creation problem. Like there is group of say 18 to 20 fields which I need to add them so the formula will be Y001+ Y002 + Y003 til Y020 right. so there are four such type of group have more then 15 fields to be added. So when I tied to run the report but it gave me error saying "Formula too long to be converted".

Can any give me sugesstion

Thanks in advance.

Kiran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 06:04 PM

    Hi,

    Add all the fields group wise and and finnaly all groups together.

    please assign points if helpful.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 21, 2007 at 06:10 PM

    Create interim column with formula of adding maximum number of possible columns, call it say column A and hide it. Use another column to and Column A + any overflows.

    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.