I have a subtotal of a whole list of details by select the sum under calculate. How do I make use of this subtotal, add to miscellaneous charges to get a grand total value. FPW seems to sum miscellaneous charges as many times as the number of details if I use subtotal+miscellaneous as the variable and select calculate sum.

Do I need to manually calculate the grandtotal myself?

My report is a simple details report without grouping.


doc doc_date amount

001 010195 100
002 010295 200
003 010395 300

subtotal 600
misc 30

total 690 ???




Tai SC