Issue when adding formula field on report header

[krystalq]

Hi,

We are trying to develop a report for unavailability of applications. We have a formula to calculate the total minutes available for the month:

100-((({#Sum of Mins}/{@Available Mins})/67)*100)

(67=total applications)

When I add this field to the report footer it gives me the right number, however, when I add it to the report header it only gives me the total of the first record (first application listed on the report) as supposed to the month total.

 

[lbass]

That's because you are using a running total which has not yet accumulated the values (except for the first record). Are you sure you need to use a running total? How is the running total set up? Are yo using a group selection formula?

-LB