Calculation on account schedule

Hi, There are occasions the totals on account schedule’s lines or columns are not calculated correctly. For example, if you want to total line 100 to 500, and line 300 have amount of $5,000, the total is $0. No matter I use 100…500 or 100+200+300+400+500 as the formula. Has anyone has this problem? Thanks Trin