Multi-Year Data Export to File

Summary

Data Export to File is incorrect if run over multiple years

Content

Hi all,

I've noticed that running a 'Data Export to File' in data management over mutliple years will result in the values for the exported years being added together, rather than exported on separate rows in the file. For example, if I run an export from Jul-19 (FY20) to Jun-21 (FY21), then data export for Jun FY20 will be equal to Jun FY20 + Jun FY21 in the export file (and the same for Jun FY21) which obviously is not correct.

This happens whether Period is pivoted or not, and means any exports that require mutliple years must be run separately, for one year at a time.