Forum Discussion

damienpage's avatar
damienpage
Qrew Cadet
10 months ago

Averages in summary reports

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
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    10 months ago

    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
    ------------------------------