How to Create a calculation field in Report Writer that Sum per column, for example:
Currency USD | |
200.00 | |
300.00 | |
500.00 | |
Total Curr: 1,000
*This post is locked for comments
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'.
Kind regards,
Leslie
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
Dear Leslie
thank you for mention i edit it https://www.dropbox.com/s/dk959piniq9wtbi/Capture22.PNG?dl=0
thank you
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 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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156