Announcements
How to Create a calculation field in Report Writer that Sum per column, for example:
Total Curr: 1,000
*This post is locked for comments
Dear Vielka Colon
you didn't need to make a calculated field to calculate the sum of the prices there is already filed ready made you just only drag it and drop in the footer of the invoice
but if you want to make another one you can go to https://support.microsoft.com/en-us/kb/950780
Abdallah,
When I clicked your link I went to the article numbered 857086, but it was about
"Error message when you try to log on to Microsoft Dynamics GP or open a window or a report in Microsoft Dynamics GP: "You don't have security privileges to this window. Contact your system administrator for assistance" "
I don't think this will help us with a calculated field. You probably had a different KB in mind; do you recall its number?
Kind regards,
Leslie
Dear Leslie
thank you for mention i edit it https://www.dropbox.com/s/dk959piniq9wtbi/Capture22.PNG?dl=0
thank you
Hello!
One thing that I would like to point out about the Article that Abdallah had mentioned is that the Report Writer KB articles should be used as a guide. This one in particular is for Bank Rec and Payroll however, it does explain how to create a Calculated field in report writer. You just need to know the information you are looking for.
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
This posting is provided "AS IS" with no warranties, and confers no rights
Hi,
If you drag the data field into the footer, you'll need to change the Display Type to 'Sum' because I think the default is 'Last Occurrence'.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
