Formula Report Painter

[Former Member]

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

[Former Member · Accepted solution]

Hi,

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

please assign points if helpful.

Regards,

[Former Member · Accepted solution]

Harish,

Iam doing in same way I am adding those 18 fields togethere and there are four such groups whose fields are more than 18.

[Former Member · Accepted solution]

Hi,

In case fields are more than 18, divide that group into subgroup and create subtotals for that subgroup and then inturn total of those subgroup. you can hide those subgroup columns.

Regards,

[former_member188826]

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.