Lotus notes basic table to act as a spreadsheet for totalling column values
Posted on 2006-06-20
I am wanting to manipulate a table within lotus notes.
The table acts as a sort of register for the month for staff.
01 02 03 04 05 06 07 ...... 31
Graham H H H S S x x x
Fred x x x S S S x x
Joe S A x x x x x x
Bill x C x x x x x x
John x x x H H H x x
What I want to do is add a Total below the last row....EG
Total off 2 2 1 3 3 2 0 0
So, basically I want to add the value of each column, based upon the amount of people on Holiday (H) and Sickness (S).
So the formula I am looking for would be something like:
Search column above and count all H and S Values and put total in the cell.
Can I use computed text for this or command language? (Struggle with lotusscript!!!)
If I can get a method for this to work it would save me a lot of valuable time!!! :o)
On from the 'total off' row I would also like to add a '% of people at work',
EG, in above table column 1: -
% people at work = (Amount of people - Total off)
---------------------------------------- X 100
Amount of people
I require this fairly urgently so if anyone can help with the commands needed it would be appreciated!!!!
Do I have to name the table columns in order to do this???