## Forum Stats

• 3,826,687 Users
• 2,260,690 Discussions

Discussions

# PBCS: Problems with a formula in row of form

Member Posts: 129
edited Sep 1, 2016 9:18AM

I have created a form and I have added a new row with this formula:

Sum([A])

I want to sum the colum A, but I don't see what I do incorrectly, because he system display #error, why?

Tagged:

• Member Posts: 249 Blue Ribbon
edited Sep 1, 2016 6:28AM Answer ✓

Hi

Kindly Write for Col A = Sum([B])

And For 2 kindly Write Sum([1])

It will work

Regards,

Chandan M

• Member Posts: 249 Blue Ribbon
edited Sep 1, 2016 4:28AM

If You want the Sum of Column then you have to add Column Formula Not the Row Formula.

Even if you want the value in row then you have to add col and row formula both then first summation will happen in col level and then the sum value will appear in row. I hope this will suffice your requirement.

Regards,

Chandan M

• Member Posts: 129
edited Sep 1, 2016 5:37AM

I want the sum of column, but this information I need view it in a row.

I will try the second option that you tell me.

• Member Posts: 129
edited Sep 1, 2016 5:59AM

I have tried the option but It isn't correct for me, because I want the sum in each column (year total, Q1, Jan, Feb... Q2...):

Besides, If I add formula in a column and after I try to sum it with a formula in a row, the system displays #error also.

• Formula in column

• Formula in row

• Member Posts: 263
edited Sep 1, 2016 6:21AM

Hello,

It seems to be working as expected not sure about the confusion, pretty straight forward.

If you want to add Administration and Financial Income on your rows just include a sum([1]) that should work and not sum([A])

Hope that helps !Vikram

• Member Posts: 249 Blue Ribbon
edited Sep 1, 2016 6:28AM Answer ✓

Hi

Kindly Write for Col A = Sum([B])

And For 2 kindly Write Sum([1])

It will work

Regards,

Chandan M

• Member Posts: 129
edited Sep 1, 2016 7:02AM

Yes, it works.

I was adding in the row this formula: sum([A]). And I should be sum([1])

Thanks a lot.

• Member Posts: 249 Blue Ribbon
edited Sep 1, 2016 7:09AM

Cool, Enjoy and all the best

Regards,

Chandan M

This discussion has been closed.