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
total 690 ???