Sum Variables

mramirezdom

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

Savatage

add a textbox and change it's sourceexp to your variable name.
View->properties
I think this is what you are talking about.

Savatage

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);

Alex_Chow

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.