Hi all, I have a long form with about 80 of the fields having a default of zero. At the bottom of these fields there is a total field and this is not recognising the default zero’s and remains empty. If I overwrite some of the zero’s manually with new zero’s, the total updates correctly. Any thoughts on what's going on? Thanks
Hi Jon,
In trying to create a test survey that duplicates your description, the calculation based on default values appears to work properly. Can you forward the XLS file so that I can test it?
Hi James, thanks for getting back to me so quickly, attached is the xls file, there are several sub totals and averages and an overall total at the bottom. The totals are normally hidden and only the averages displayed, I made some of them number types so I could see the empty fields.
Jon Marks | Senior Analyst, Environmental Science
GREATER WELLINGTON REGIONAL COUNCIL
Te Pane Matua Taiao
2 Fryatt Quay, Pipitea | Wellington 6011
T: 04 830 4140 | M: 027 609 8912
Hi James, I’ve just loaded up version 3.0.132 of the app and it seems to be doing the average and total ok now.
Thanks for your help
Jon Marks | Senior Analyst, Environmental Science
GREATER WELLINGTON REGIONAL COUNCIL
Te Pane Matua Taiao
2 Fryatt Quay, Pipitea | Wellington 6011
T: 04 830 4140 | M: 027 609 8912
www.gw.govt.nz