Total

Horse06
Horse06 Member Posts: 496
edited 2013-10-17 in NAV Three Tier
Hi expert, currently I am trying to create a report which group the date and the salesperson and then sum the total sales for the salesperson of a day. The report is working now. But if I want to grand total all of of the salesperson for all the dates, how to accomplish this? Thank you!

Comments

  • manivino_mv
    manivino_mv Member Posts: 13
    Hi,

    did u set the TotalFields property for those fields which u have maintain the total as per the group level as well as grand total.



    Regards,
    Mani..
    Mani
  • Horse06
    Horse06 Member Posts: 496
    Thank you for your response expert! But there is no TotalFields property in NAV2013. I am using sum function in RDLC. Please advise! Thank you!
  • manivino_mv
    manivino_mv Member Posts: 13
    Hi ,

    Sorry, i did not see that u r asking in 2013. For 2013 u have to create a global variable and make a sum to all the group total value. Instead of Total field Property u can use createtotals() function. This will maintain the total value for grand total. Still if u have any doubt refer Inventory valuation Report - there is a Global field "ValueOfInvIncreases" to show the grand total. you can find the solution how to do that.
    Mani

Categories