You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Multi-Year Data Export to File

Accepted answer
154
Views
8
Comments
edited May 20, 2020 1:07PM in Planning 8 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!