I have created an account schedule which has 36 rows. I want to total 30 rows, however when I enter the formula 4+5+6+7+8+9+10+11+12+13+14+15+16+17+18+19+20+21+22+23+24+25+26+27+28+29+30+31+32+33+34+35 in the totaling field, I get the error message “the maximum length for string is 80”.
Is there a way to sum the 30 rows? I am using Navision 2009.
In your chart of accounts have a totoal account, then just call it on the account schedule as a total account. No need for all of your hidden lines then. Construct the COA well and the Account schedules are easier to construct.
The design you have shown in the screenshot shows you hiding the details on the report and just printing the total. If you had a total report doing this it would be easy. Whilst you have to design the report you also have to tell the client the best way to utilise the software.