Hi David,
thanks for the offer of further assistance. I attach my zipped project (Calcdata.zip Calcdata.zip ) where I have been able to implement the calculate Total and calculate Average per row as per the adjacent image.
My continuing challenges are:
1. To discover how to calculate and display a running total in a further column alongside the period total (Pertotal) and the Period average (Peravg) to show the cumulative total value per row (as new rows (periods) of data continue to be added).
2. To also calculate and display Column sum values per each separate category of main data input (eg for the Columns for Manufha, Servicesha, Otherha as column totals inserted below the last row entry).
3. Lastly, I tried (unsuccesfully) to make the calculated Pertotal and Peravg fields Read Only so that user does not try to overwrite them at time of adding new data to the input columns but this seemingly is not working; perhaps I have to make them readonly in more than one place?
4. Final puzzle: not sure where in the flow to construct a database update action so that the values calculated in Tersus are captured back into MySql database table (the cols in MySql currently remain NULL since the values are being calculated on the client side). Does one modify/replace the existing Table wizard modelling section that currently applies the Save Button as "Database Insert" and simply make it "Database Update" instead (could it be that simple?) or is it a case that another separate Action step needs to be created and applied elsewhere.
Thanks for your patience and help.
Regards, Al
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign