Excel Reports: Replicate a number field, that is not a table field, in an Excel Reports
One of our customers created a workload form that tracked the year of entry as a numeric field, e.g. 2012, 2011 etc. They also had a table in the event form that tracked exercise workload during the session. When each entry was exported to the Excel Reports, the year of entry (e.g. 2012) only appeared with the data in the first row of data for that event. When they tried to produce a pivot table using 2012 as a filter, only the first row's data was pulled into the pivot table. You can now set up a numeric field to replicate in the athlete history and Excel Reports when there is a Table in the Event Form.
Does one of your numeric fields need to replicate in an Excel Pivot Table? To set up a numeric field so that it is replicated in the Excel Reports see the steps below.
On the application in the athlete history, the example here shows the number field (Year number example) has repeat and filled down to all of the rows. Another number was added to this form that was set not to repeat. This highlights the difference between the fields
When you create an Excel Report, the data that is set to Repeat, will appear in all of the Rows in the Excel Output
When the different number formats are used in Pivot Tables, you can see that for the repeated field all of the table records appear. For the non repeated, only 2 table records appear.
You need to think very carefully about where you implement this "Repeat Field"
If you set a number field to repeat (in the Athlete History or Excel reports) and you are doing a sum with those numbers in a pivot or even in the athlete history, then the "sum" will sum all of the repeated fields. The image here shows the year being set to sum in the athlete history. This is just an example to highlight how the repeated fields are summed and how they affect system calculations.
0 Comments
Add your comment