[Solved] Need to add Base values in Writer Table Cell
Posted: Sat Oct 24, 2009 9:55 am
sorry for being noisy, but i have a problem that gets me crazy.
I have a mysql database registered with base.
I did a table of writer and connected some fields to cells of that table. i can perfectly print all documents.
But now I want to have a cell which must have as a value the sum of 6 cells.
I explain better.
In that table I have 6 cells which take value directly from db( they are integers) and i would like to have 7th cell which must be the sum of previous 6 cells. In sql it would be SELECT SUM(1+2+3+4+5+6) GROUP BY id.
How can I do?
Sorry, but perhaps I don't know something, because formula =sum<B1:B6> gives me an error in inserting formula (also = sum>B1:B6> does the same).
I'm getting crazy
Thanks
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)
I have a mysql database registered with base.
I did a table of writer and connected some fields to cells of that table. i can perfectly print all documents.
But now I want to have a cell which must have as a value the sum of 6 cells.
I explain better.
In that table I have 6 cells which take value directly from db( they are integers) and i would like to have 7th cell which must be the sum of previous 6 cells. In sql it would be SELECT SUM(1+2+3+4+5+6) GROUP BY id.
How can I do?
Sorry, but perhaps I don't know something, because formula =sum<B1:B6> gives me an error in inserting formula (also = sum>B1:B6> does the same).
I'm getting crazy
Thanks
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)