Weitere Formelbeispiele

STO/Schulart zu Sachsen zusammenfassen

• Summenbildung in Pivottabelle möglich
• Spaltenname "E" anpassen!

CASE
       WHEN E like 'GS%' THEN 'Sachsen'
       WHEN E like 'OS%' THEN 'Sachsen'
       WHEN E like 'B2:OS%' THEN 'Sachsen'
       WHEN E like 'GYM%' THEN 'Sachsen'
       WHEN E like 'B2:GYM%' THEN 'Sachsen'
       WHEN E like 'B2:KOL%' THEN 'Sachsen'
       WHEN E like 'AFS%' THEN 'Sachsen'
       WHEN E like 'P63%' THEN 'Sachsen'
       WHEN E like 'GMS%' THEN 'Sachsen'
       WHEN E like 'BBS%' THEN 'Sachsen'
END

Schularten anpassen

BBS

Schulart zu BBS zusammenfassen:

• Spaltenname "D" anpassen!

  CASE
       WHEN D like 'BGY%' THEN 'BBS'
       WHEN D like 'BS/BS%' THEN 'BBS'
       WHEN D like 'BS/BGJ%' THEN 'BBS'
       WHEN D like 'BS/gBVJ%' THEN 'BBS'
       WHEN D like 'BS-F/BS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (t)%' THEN 'BBS'
       WHEN D like 'FS/FS (v)%' THEN 'BBS'
       WHEN D like 'FS/FS (t)%' THEN 'BBS'
       WHEN D like 'FOS/FOS%' THEN 'BBS'
       WHEN D like 'BS-F/kBVJ%' THEN 'BBS'
       WHEN D like 'BS/BVJ%' THEN 'BBS'
       WHEN D like 'BS/VK%' THEN 'BBS'
       WHEN D like 'BS-F/BvB%' THEN 'BBS'
       WHEN D like 'BS/BvB%' THEN 'BBS'
       WHEN D like 'BS-F/BS%' THEN 'BBS'
       WHEN D like 'BS-F/BVJ%' THEN 'BBS'
   END

ABS

B2 zu OS und GYM zuordnen:

• Spaltenname "E" anpassen!

  CASE
       WHEN E like 'GS%' THEN 'GS'
       WHEN E like 'OS%' THEN 'OS'
       WHEN E like 'B2:OS%' THEN 'OS'
       WHEN E like 'GYM%' THEN 'GYM'
       WHEN E like 'B2:GYM%' THEN 'GYM'
       WHEN E like 'B2:KOL%' THEN 'GYM'
       WHEN E like 'AFS%' THEN 'AFS'
       WHEN E like 'P63%' THEN 'P63'
       WHEN E like 'GMS%' THEN 'GMS'
       WHEN E like 'BBS%' THEN 'BBS'
   END