The rule in plain words
Total must equal these three added up:
- Female
- Male
- Non-binary
All the values are in the number of executive directors ([reference period]) column (0010) of R 17.00.
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
Female + Male + Non-binary = Total
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Add up the parts in your file and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong row, or the total is out of date.
- 04EBA compares the values exactly here: there is no rounding tolerance.
- 05It runs only when your filing indicators mark R 17.00 as reported.
- 06This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Newly appointed executive directors (including CEO) (R 17.00)
Rows
- 0010Male
- 0020Female
- 0030Non-binary
- 0040Total
Column
- 0010Number of executive directors ([REFERENCE PERIOD])
A worked example
The first of its checks, with simple numbers.
Illustrative values
Female1,200
Male800
Non-binary450
Together2,450
What the rule then expects
Total must then be 2,450.
2,450Passes
2,550Fails
A file that reports 2,450 passes. One that reports 2,550 fails, by 100.
The numbers are illustrative.
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
sum({R_17.00,r0020,c0010,},{R_17.00,r0010,c0010,},{R_17.00,r0030,c0010,}) = {R_17.00,r0040,c0010,}Other rules on R 17.00
Every REM diversity rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.