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.

For any numeric field in the Builder you can set it to "Repeat Field in Excel" =Yes

For any numeric field in the Builder you can set it to "Repeat Field in Excel" =Yes

The "Repeat field in excel reports" only appears when there is a Table in the Event Form

The "Repeat field in excel reports" only appears when there is a Table in the Event Form

When there is no Table in the Event Form, the" Repeat Field in excel report" button will NOT appear

When there is no Table in the Event Form, the" Repeat Field in excel report" button will NOT appear

When the Button is enabled for the fields that you require Save the Event Form

When the Button is enabled for the fields that you require Save the Event Form

The Event Form being entered on the system with 4 rows entered in the Table.

The Event Form being entered on the system with 4 rows entered in the Table.

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

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.

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.

Now when the year is used as a reference in a pivot table, all of the rows for the record will be pulled through

You need to think very carefully about where you implement this "Repeat Field"

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

E-Mail me when someone replies to this comment