{"title":"Students in specific areas example","exportedDatetime":"2026-11-03 09:21:51","report":{"reportClass":"Student_Report_EnrolledStudents","title":"Students in specific areas example","scopes":[{"baseEntityType":1,"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1},"filters":[]}],"groupings":[],"postGroupingFilters":[],"columns":[{"fieldClass":"Student_Field_Name","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Person_LastNameFirstName","identifier":"column4570","summaryRowFormulaClass":"Report_SummaryRow_Formula_RowCount","conditionalFormatters":[]},{"fieldClass":"Person_Field_PrimaryPostalAddressPostalCode","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column4571","summaryRowFormulaClass":"Report_SummaryRow_Formula_RowCount","conditionalFormatters":[]},{"fieldClass":"Person_Field_PrimaryPostalAddressTown","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"","formatterClass":"Field_Formatter_Base","identifier":"column4588","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"formula":"=IF(SEARCH(\"NW1 \", \"{{ column4571 }}\")=1, 1, IF(SEARCH(\"NW2 \", \"{{ column4571 }}\")=1, 1, IF(SEARCH(\"NW3 \", \"{{ column4571 }}\")=1, 1, 0)))","dataType":"int"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"NW1-NW3?","formatterClass":"Field_Formatter_Numeric_0dp","identifier":"column4578","summaryRowFormulaClass":"Report_SummaryRow_Formula_Sum","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"formula":"=IF(SEARCH(\"WF3 \", \"{{ column4571 }}\")=1, 1, IF(SEARCH(\"WF10 \", \"{{ column4571 }}\")=1, 1, IF(SEARCH(\"Leeds\", \"{{ column4588 }}\")=1, 1, 0)))","dataType":"int"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Leeds, WF3, WF10?","formatterClass":"Field_Formatter_Numeric_0dp","identifier":"column4587","summaryRowFormulaClass":"Report_SummaryRow_Formula_Sum","conditionalFormatters":[]}],"orderings":[{"fieldClass":"Student_Field_Name","fieldParams":[],"direction":"ASC","targetType":"BASE_MODELS","targetIndex":null,"transformationClass":"Report_Transformation_Self"}],"collations":[]}}