2 Replies Latest reply on Mar 25, 2014 9:17 AM by DocHollywood

    Calculation in sub summary of Report?



      Calculation in sub summary of Report?




           I'm struggling with a seemingly simple issue. 

           I have a report that contains sub summaries to issue check payments to different parties at the end of the month. The check amount (the number) is showing just fine, based on a summary field that adds up all the individual amounts to the check total. 


           The problem comes into play when I try to convert these amounts in the sub summary fields to a text-based sequence of words: 


           My summary payment field will read 10.- 

           The AmountinWords calculation field should then read Ten Dollars - which it does, also. 

           BUT: On my sub summary reports, ALL the AmountinWord fields contain the same value - based on the last amount in my succession of summary payment fields. 


           How on earth do I get the AmountinWord Field to be calculated for each of my sort by sub summary fields?


           Thank you!