Calculation Page

Not really sure if I understand the exact question but it looks like you need to perform all these calculations in the code.
I guess this can be, for instance, an additional View page of one of those three tables. You can just remove everything you don't need, insert a code snippet and run your calculations there.

Thanks Sergey.
I have tried first using code snippets from the manual to get something that works. The examples don't seem to be quite right for what I'm after but have added some simple ones to my toolbox like current time and build number.

Im sure what I need would be fairly simple ☺
I need in this additional view a sum(Amount) from a table, the sum of Machine Tonnage.

Any help from anyone would be welcome ☺☺☺

On the Field's Page, click 'Properties' and then click 'Field Events' change 'Event' from "click" to "change".
Now click 'Add Event'
Put your calculations here using javascript and it will save it to the database.
Here is some documentation:
https://xlinesoft.com/phprunner/docs/field_events.htm

Thanks Need2sleep, I have looked at the documentation for that and not sure that its the right solution forward for me.

I have tables set up for users to input data (small not very big tables) I have then created a custom view with the intention of adding code snippets to collect information from the different tables, as Sergey suggests.
The custom view is a copy of one of the tables and I have summed one of the sums I require with SQL.
SELECT

SUM(Amount) AS Expense_Total,

Amount,

ownerid

FROM Expenses
But I require this with a code snippet as I also require a sum showing from another table and then further calculations. ☺

It really hard to understand what kind of help you looking for. Right now it says "I have to perform a bunch of calculations and I don't know where to start" and it is not clear what kind of answer you looking for. I will help you split your question into a several smaller parts and make each part of the question more specific.

Thanks Sergey

I have followed your suggestion I have created a custom view page and deleted everything I don't need and added a code snippet.

First of all I am looking to show a sum from one of my tables "expenses" of the column "Amount". I have used the following:-
$sql = "select sum(Amount) as Stotal from Expenses ";

$rs = CustomQuery($sql);

$data = db_fetch_array($rs);

echo "Expense Total: " . $data["Stotal"];
This has given me a result but it seems to be exactly twice the amount that it should be ie 417406 instead of the correct amount 208703?

Though is not really a PHPRunner question it is a great example of the question that can be understood and helped with.
As a first step, run the following query manually against your database using the software like phpMyAdmin

Once it returns correct results use the same query in your code snippet and it will do exactly the same thing.

Once it returns correct results use the same query in your code snippet and it will do exactly the same thing.

Thanks Sergey, this highlighted what my problem was when I looked I realised that it was user group permissions etc that was causing double results. I had created two accounts and populated with dummy data of the same. The sql query was returning full results instead of results by ownerid. Will have to check out user group permissions.

Thanks for pointing me in right direction.

Once it returns correct results use the same query in your code snippet and it will do exactly the same thing.

Code snippet seems to be working correctly but not adhering to ownerid security settings. I have checked all the security settings and users can see and edit their own data only.

The code snippet sums all user data, is there something I need to add to it to get it to sum just the current user data?

Code snippet is just the code and it doesn't know anything at all about your project settings. You will have to write your code the way it only returns data for the current user.