Sum Variables

mramirezdom
Member Posts: 6
Hi everybody, I'm new in this forum and this ERP. My problem is in a report, I used a global variable to do some operations with fields, now at the footer section, I need to sum those calculated fields. In the TotalFields and GroupTotalFields properties I have no problem with natural fields, but I can not put a variable name there. Can you Help me
Thanks in advance
Thanks in advance
0
Comments
-
add a textbox and change it's sourceexp to your variable name.
View->properties
I think this is what you are talking about.0 -
or are you talking about CREATETOTALS function
Use this function to maintain totals for a variable in the same way as totals are maintained for fields by using the TotalFields Property.
OnPreDataItem<>
CREATETOTALS(MyVariable1,MyVariable2,MyVariable3);0 -
In order to group, you'll need to specify the GroupTotals property on the dataitem you wish to group.
Since you're new to report development, you might consider purchasing the Dynamics NAV programming book. It has helped a lot of new programmers out.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions