Discussions
Categories
 17.9K All Categories
 3.4K Industry Applications
 3.3K Intelligent Advisor
 63 Insurance
 536.4K OnPremises Infrastructure
 138.3K Analytics Software
 38.6K Application Development Software
 5.8K Cloud Platform
 109.5K Database Software
 17.5K Enterprise Manager
 8.8K Hardware
 71.1K Infrastructure Software
 105.3K Integration
 41.6K Security Software
PBCS: Problems with a formula in row of form
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?
Best Answer

Hi
Kindly Write for Col A = Sum([B])
And For 2 kindly Write Sum([1])
It will work
Regards,
Chandan M
Answers

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

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.

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

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

Hi
Kindly Write for Col A = Sum([B])
And For 2 kindly Write Sum([1])
It will work
Regards,
Chandan M

Yes, it works.
I was adding in the row this formula: sum([A]). And I should be sum([1])
Thanks a lot.

Cool, Enjoy and all the best
Regards,
Chandan M