http://histodata.ch//WRWiki/index.php?action=history&feed=atom&title=LohnTest LohnTest - Versionsgeschichte 2026-09-27T13:50:37Z Versionsgeschichte dieser Seite in WeihnachtsRechnungen MediaWiki 1.44.2 http://histodata.ch//WRWiki/index.php?title=LohnTest&diff=5454&oldid=prev ERadmin am 25. März 2025 um 14:33 Uhr 2025-03-25T14:33:05Z <p></p> <p><b>Neue Seite</b></p><div>__NOCACHE__<br /> &lt;!--{{#cargo_query:<br /> tables=bookings<br /> |fields=_pageName=Buchung,<br /> DATE_FORMAT(datum, &quot;%e.%b&quot;)=  ,<br /> itemtype=Art,<br /> department=Abt,<br /> LEFT(purpose,25)=Zweck,<br /> valDenar=Betrag,<br /> IF(person__full&gt;&quot;&quot;,CONCAT(&quot;[[&quot;,person__full,&quot;]]&quot;),personOrig)=Person(en),<br /> IF(pendenz&gt;&quot;&quot;,&quot;P&quot;,&quot; &quot;)=,<br /> |where=purpose=&quot;Lohn&quot;<br /> |format=barchar<br /> |limit=10<br /> }}<br /> <br /> {{#cargo_query:<br /> tables=bookings<br /> | fields=purpose, valDenar<br /> | group by=purpose<br /> | format=outline<br /> | barwidth=20<br /> | bars=blue<br /> }}<br /> --&gt;<br /> ----<br /> {{#cargo_query:<br /> tables=bookings<br /> | fields=year, purpose, round(avg(valDenar)/240,1)=AVG, count(valDenar)=Anz<br /> | group by=year<br /> | where=purpose=&quot;Lohn&quot;<br /> }}<br /> ----<br /> {{#cargo_query:<br /> tables=bookings<br /> | fields=year, AVG(valDenar)=totalVal, COUNT(valDenar)=Anzahl<br /> | group by=year<br /> | where=purpose=&quot;Lohn&quot;<br /> }}</div> ERadmin