I have often thought it a bit strange that you cannot total a calculated field, particularly when it is a number. I managed to acheive this a while ago but had forgotten how I did it so now I am going to put in down in writing so that I don't forget!
You need to change the view to a datasheet one in Frontpage. Then go to the code and find the ??? that ends the display of all the data. Between that and the ??? enter another row and the required number of table cells.
Then add the xsl code that will sum that field - in my case this makes the xml like this:
|
Total Cost: <?xml:namespace prefix = xsl /><xsl:value-of select="sum(<A href='$Rows/@TotalCost)"></xsl:value-of>$Rows/@TotalCost)"/>> |
For some reason I don't seem to have the option of formatting this as a number in FrontPage so I guess I will need to do that in the XSL as well.