Skip to main content
Question

Averages in summary reports

Forum|alt.badge.img+5

Hi all.....

Have done a comparison summary report for sets of details in 2023 vs 2024.

To calculate the averages, i have used the following 'summary fields'

On the second field, is there a way to calculate the number of days (year to date) so i don't have to manually keep changing the number, and bonus points if someone could tell me how i would remove the 'bogus' averages appearing in each line (due to above)

Cheers,

Damien



------------------------------
damien page
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9

    For your first question - if you want the current years to date you can just use DayOfYear(Today()) to return the current day in the calendar year. 

    Can you provide more detail though about what you mean by the 'bogus' averages?



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement