Created
June 5, 2023 10:26
-
-
Save nsdevaraj/47fa93cff9585ee244680e8d112cea6a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"version":2,"config":{"sorting":[],"pagination":{"enable":false,"pageRowCount":10,"autoRowCount":"hide","view":"browser","pageNo":0,"paginationHeight":20,"currentPageNumber":0},"headerOption":{"showHeaderIndicator":true,"showHeader":true},"enableSign":false,"isEditMode":true,"columnTitleConfigs":[{"value":"NK","id":"Sum(NK Abrechnung Extension.Anteil)","levelId":"measuresTitle"}],"overRideScaleFactor":true,"interactivity":{},"compareHeader":{"left":{"label":"","values":[]},"right":{"label":"","values":[]}},"tableState":{"rowHierarchyLevel":{},"compareMeasure":null,"expandCollapseIcon":"plusMinusSquare","columnExpandCollapseIcon":"arrows","columnHierarchyLevel":{},"headerHeight":25},"measureBasedHeader":false,"isReadModeConfigModified":false,"layout":"HIERARCHICAL","rowExpandCollapseOptions":{"rows":{"Grand__Total":{"expanded":true},"Nebenkosten":{"expanded":true}},"expandTillDescendant":{},"gridState":null,"levelStates":[{"level":0,"state":0},{"level":1,"state":1},{"level":2,"state":1}],"maxLevelExpanded":null},"chartTitleOption":{"show":true,"primaryTitleText":"","customTitleHeight":22,"measurescale":"","currencyValue":"","titlContainer":{"display":"flex","flexDirection":"column","height":"22px"},"primaryTitle":{"color":"#ffffff","fontSize":"14px","fontWeight":"normal","fontStyle":"normal","paddingRight":"5px","lineHeight":"22px"},"secondaryTitle":{"color":"#ffffff","fontSize":"14px","fontWeight":"normal","fontStyle":"normal","paddingRight":"5px","lineHeight":"22px","order":2},"secondaryTitleFont":{"fontWeight":"normal"},"titleMeasure":{"color":"#ffffff","fontSize":"14px","fontWeight":"normal","fontStyle":"normal","lineHeight":"22px","order":1},"unitScale":{"fontWeight":"bold"},"measureHeading":[]},"chartCustomTitle":{"secondaryTitle":"","measureTitle":"","primaryTitle":"","customTitle":""},"breakConfig":{"sectionBreak":{"enabled":false,"breakBy":""},"pageBreak":{"rowBreakBy":"","columnBreakBy":""}},"miscellaneous":{"enableFooter":true,"showInfoRiverLogo":true,"footerUrl":"https://inforiver.com/","footerText":"inforiver.com","showTooltip":true,"isUserChangedFooter":false},"globalStyles":{"fontFamily":"Inforiver Sans","fontSize":"12","fontWeight":"normal","fontStyle":"normal","varianceBarFont":12,"headerFormat":false,"headerHeight":30,"headerFontSize":"14px","headerFontColor":"#212121","rotateLabels":{"enabled":false,"angle":0},"headerLabelOrient":"initial","isHeightUpdatedManually":false,"isFontFamilyChanged":false,"textColor":"#212121","rowHeight":30,"hierarchyfontWeight":"bold","hierarchyFontStyle":"normal","columnHierarchyFontWeight":"bold","columnHierarchyFontStyle":"normal","subTotalFontWeight":"semiBold","blankRowLabel":"(Blank)"},"notes":{"show":true,"displayAnnotations":"view","autoFit":true,"annotations":[],"columnAnnotations":[],"indicatorType":"numbered","indicatorPosition":"default","persistProperty":{"bgColor":"rgba(255,255,255,0.9)","lineColor":"rgba(3,169,244,0.7)","borderColor":"rgba(3,169,244,0.7)","iconColor":"rgba(0, 120, 212, 0.7)","displayOptions":4,"iconSize":14},"showFootnote":false,"rowLevelComments":false,"enableReply":true,"annotationNote":"grid","annotationHeight":15,"annotationColumnCount":2,"indicatorSize":12,"footNoteHeight":15,"footNoteColumn":3,"showTimestamp":true,"showUsername":true,"defaultReference":false},"themeColors":{"showTable":false,"positiveColor":"#4e89f4","negativeColor":"#4e89f4","enableVarianceColor":false,"chartTheme":"trafficlights","chartThemeTable":false,"invertVarianceColor":false,"themeType":"trafficlights","previousThemeType":"trafficlights","tableThemeType":false,"valueColor":"","enableRowHover":"off","rowHoverColor":"#f5f5f5","rowHoverTextColor":"#212121","rowOddColor":"#f5f5f5","rowEvenColor":"#ffffff","measureOnlyHighlight":false,"lineStyleRecentColor":"","highContrast":null},"rowReorder":{"enabled":false,"rowOrderConfig":{"true":["true__Bruttolohn__inklusive__Sozialabgaben__der__Hauswartung","true__Kosten__f__r__Brennstoff__l__Gas__oder__andere__Energie__","true__Kosten__f__r__Wasser__zum__Duschen__Kochen__etc__","true__Periodischer__Brennerservice__Tankrevision__KaminfegerIn","true__Rasenm__hen__Bew__ssern__bei__Trockenheit","true__Strom__f__r__allgemein__zug__ngliche__R__ume","true__CAL_ROW3"],"Grand__Total":["Nebenkosten","Fremdperiodenanteil","CAL_ROW33","CAL_ROW9__empty_0","CAL_ROW9","CAL_ROW19","CAL_ROW38","Akonto__geleistet__empty_0","Akonto__geleistet","Saldo","CAL_ROW31"],"ROW_GROUP_1":["CAL_ROW13","Periodenanteil","CAL_ROW7"],"ROW_GROUP_2":["CAL_ROW13","CAL_ROW9"]},"rowOrderConfigMeta":{"true":["true__CAL_ROW3"],"Grand__Total":["CAL_ROW5","Akonto__geleistet","Verrechnungshonorar__3__","CAL_ROW7","CAL_ROW7","Verrechnungshonorar__3__","CAL_ROW9","CAL_ROW11","CAL_ROW13","CAL_ROW13","Verrechnungshonorar__3____empty_0","CAL_ROW11","Akonto__geleistet__empty_0","Akonto__geleistet__empty_0","Akonto__geleistet","CAL_ROW13","ROW_GROUP_2","ROW_GROUP_2","CAL_ROW13","CAL_ROW9","CAL_ROW9","CAL_ROW15","CAL_ROW15","CAL_ROW15","CAL_ROW13","CAL_ROW9__empty_0","CAL_ROW7","CAL_ROW9__empty_0","CAL_ROW7","CAL_ROW17","CAL_ROW17","CAL_ROW13","CAL_ROW13","CAL_ROW13","CAL_ROW19","CAL_ROW19","CAL_ROW19","Fremdperiodenanteil","CAL_ROW31","CAL_ROW33","CAL_ROW33","CAL_ROW31","Saldo"],"ROW_GROUP_1":["Periodenanteil"],"ROW_GROUP_2":["CAL_ROW13"]}},"columnHierarchySort":{},"compareMesLabelAlign":false,"gridStyles":{"majorGridLines":"single","horizontalMinorGridLines":"off","headerGridLines":false,"verticalMinorGridLines":"off","compactSplitLine":false,"compactSplitLineColor":"#A6A6A6","chartSpacing":true,"topSpace":0,"bottomSpace":0,"leftSpace":0,"rightSpace":0,"titleAndChartSpace":4,"indentSpacing":10,"columnSpacing":"auto","columnSpacingValue":5,"majorGridColor":"#b0b0b0","horizontalMinorGridColor":"#E6E6E6","verticalMinorGridColor":"#E6E6E6","lineStyleColor":"#666666","lineStyleFormat":"solid","enableCategoryLabelColor":false,"categoryLabelColor":"#DDDDDD","showVAHighlight":true,"isLevelIndent":false,"showExpandCollapse":false,"gridBackground":"#FFFFFF","direction":"ltr"},"groupInColumn":true,"numberFormatting":{"enabled":true,"formatType":"flexible","enablePrefixAsUnit":true,"ibcsformat":false,"thousandSeperator":"'","decimalSeperator":".","noOfDecimal":2,"noOfDecimalPercent":2,"prefix":"","suffix":"","scalingFactor":"auto","showScalingUnit":true,"customizeScalingLabel":false,"scalingTextType":"medium","thousands":"k","billions":"b","millions":"m","trillion":"t","thousandsMediumText":"in k","millionsMediumText":"in m","billionsMediumText":"in b","trillionMediumText":"in t","thousandsFullText":"in Thousands","billionsFullText":"in Billions","millionsFullText":"in Millions","trillionFullText":"in Trillions","crores":"c","lakhs":"l","semanticFormatting":false,"positiveValueColor":"#4e89f4","positiveValueFormat":"x","negativeValueColor":"#4e89f4","negativeValueFormat":"-x","showNegativeSign":false,"showPercentageSymbol":false,"showZeroAs":"zero","customZeroText":"","showNullAs":"blank","customNullText":"","tooltipDecimal":"1"},"calculatedColumns":[{"id":"CALC_COL_36","name":"Anteil Gruppe","formula":"IF(AND(CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp,Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp),CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp/Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp,BLANK)","category":[],"measures":[],"depMeasures":[],"desc":"","dataMap":{},"operation":"FXP","deps":null,"offset":0,"isHierarchyColumn":false,"simulationSlider":true,"simulationRange":[-100,100],"varianceFormattingStyle":"POSITIVE","blendDirection":"vertical","columnEditMode":"inBothMode","scenarioSimulationSlider":true,"showScenarioVariance":true,"type":"NUMBER_COLUMN","versionNumber":2,"aggregation":null,"linkedSimulations":null,"editConditionFormula":"","forecastStartPeriod":{"value":""},"isUpdated":true,"displayName":"Anteil Position","enableAllocateParent":true},{"id":"CALC_COL_39","name":"Anteil Total","formula":"IF(Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp.TOTAL > 0,\n Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp / Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp.TOTAL,\n BLANK)","category":[],"measures":[],"depMeasures":[],"desc":"","dataMap":{},"operation":"FXP","deps":null,"offset":0,"isHierarchyColumn":false,"simulationSlider":true,"simulationRange":[-100,100],"varianceFormattingStyle":"POSITIVE","blendDirection":"vertical","columnEditMode":"inBothMode","scenarioSimulationSlider":true,"showScenarioVariance":true,"type":"NUMBER_COLUMN","versionNumber":2,"aggregation":"avg","enableAllocateParent":true,"linkedSimulations":null,"editConditionFormula":"","forecastStartPeriod":{"value":""},"isUpdated":true,"displayName":"Anteil Total"},{"id":"CALC_COL_48","name":"% Cont. of AC","formula":"","category":[],"measures":[],"depMeasures":["CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp"],"desc":"","dataMap":{},"operation":"PCBP","deps":null,"offset":0,"isHierarchyColumn":false,"simulationSlider":true,"simulationRange":[-100,100],"varianceFormattingStyle":"POSITIVE","blendDirection":"vertical","columnEditMode":"inBothMode","scenarioSimulationSlider":true,"showScenarioVariance":true,"type":"NUMBER_COLUMN","versionNumber":2,"aggregation":"avgLeaf","linkedSimulations":null,"editConditionFormula":"","forecastStartPeriod":{"value":""},"isUpdated":true},{"id":"CALC_COL_55","name":"% Cont. of Total BK","formula":"","category":[],"measures":[],"depMeasures":["Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp"],"desc":"","dataMap":{},"operation":"PCBP","deps":null,"offset":0,"isHierarchyColumn":false,"simulationSlider":true,"simulationRange":[-100,100],"varianceFormattingStyle":"POSITIVE","blendDirection":"vertical","columnEditMode":"inBothMode","scenarioSimulationSlider":true,"showScenarioVariance":true,"type":"NUMBER_COLUMN","versionNumber":2,"aggregation":"avgLeaf","linkedSimulations":null,"editConditionFormula":"","forecastStartPeriod":{"value":""},"isUpdated":true}],"calculatedColumnMeta":{"newColumnIndex":60},"totalUtility":{"rowGrandTotal":true,"rowGrandTotalPosition":"below","rowSubTotalPosition":"below","columnGrandTotal":true,"columnGrandTotalPosition":"right","columnSubTotalPosition":"clear","summaryTotal":false,"rowForSubtotal":false,"freezeTotal":true},"dynamicRowConfig":[{"label":"Verrechnungshonorar 3%","id":9,"formula":"R_CAL_ROW33 * 0.03","type":1,"previousRowId":"Akonto__geleistet","version":2,"parentId":"Grand__Total","pcbToRow":null,"isTemplateFormatting":false,"disabled":false,"includeToTotal":true,"includeInChart":false,"enableAllocateParent":false,"allocateOperation":"by_weight","spreadByRowId":null,"templatePosition":"auto","isDifferedRow":false,"isUpdated":true},{"label":"Subtotal","id":19,"formula":"R_CAL_ROW33+ R_CAL_ROW9","type":1,"previousRowId":"Akonto__geleistet","version":2,"parentId":"Grand__Total","pcbToRow":null,"isTemplateFormatting":false,"disabled":false,"includeToTotal":false,"includeInChart":false,"enableAllocateParent":false,"allocateOperation":"by_weight","spreadByRowId":null,"templatePosition":"auto","isUpdated":true,"isDifferedRow":false},{"label":"Effektive Nebenkosten","id":33,"formula":"R_Nebenkosten + R_Fremdperiodenanteil","type":1,"previousRowId":"Fremdperiodenanteil","version":2,"parentId":"Grand__Total","pcbToRow":null,"isTemplateFormatting":false,"disabled":false,"includeToTotal":false,"includeInChart":false,"enableAllocateParent":false,"allocateOperation":"by_weight","spreadByRowId":null,"templatePosition":"auto","isDifferedRow":false,"isUpdated":true},{"label":"Akonto Anteil","id":38,"formula":"IF(R_Akonto__geleistet,\n R_Akonto__geleistet*-1/R_CAL_ROW19,\n BLANK)\n","type":1,"previousRowId":"Akonto__geleistet","version":2,"parentId":"Grand__Total","pcbToRow":null,"isTemplateFormatting":false,"disabled":false,"includeToTotal":false,"includeInChart":false,"enableAllocateParent":true,"allocateOperation":"by_weight","spreadByRowId":null,"templatePosition":"auto","isDifferedRow":true,"isUpdated":true}],"enableWordWrap":true,"rowCellFormatting":{},"cfProps":{"enabled":true,"rules":[{"enabled":true,"highlightedMeasure":"delPY_PER","name":"delPY_PER-1358614097","ruleType":"rule","displayName":"ΔPY% < 0","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delPY_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delPY_PER","operator":"<","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"delPL_PER","name":"delPL_PER302489235","ruleType":"rule","displayName":"ΔPL% <= -10","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delPL_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delPL_PER","operator":"<=","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"delFC_PER","name":"delFC_PER1075604900","ruleType":"rule","displayName":"ΔFC% <= -10","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delFC_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delFC_PER","operator":"<=","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"delPYPL_PER","name":"delPYPL_PER-340318089","ruleType":"rule","displayName":"PL - PY % <= -10","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delPYPL_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delPYPL_PER","operator":"<=","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"delFCPY_PER","name":"delFCPY_PER1138093097","ruleType":"rule","displayName":"FC - PY % <= -10","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delFCPY_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delFCPY_PER","operator":"<=","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"delFCPL_PER","name":"delFCPL_PER-1413848124","ruleType":"rule","displayName":"FC - PL % <= -10","basedOn":"PY","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"both","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"font","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","enableCustom":false,"isTextGroupAltered":false,"targetValues":[],"targetValueType":"percent","iconGroupValues":[],"textGroupValues":[],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"delFCPL_PER","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"delFCPL_PER","operator":"<=","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"PY","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"PY","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"PY","toMeasure":"PY"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"chevron-up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","lineColor":"#666666","lineStyle":1,"iconGroupName":"accept","textGroupName":"segmentation"},{"enabled":true,"highlightedMeasure":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","highlightedMeasureName":"Sum(NK Abrechnung Extension.Anteil)","name":"-883345515","ruleType":"classification","displayName":"Rule 1","basedOn":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","basedOnMeasureName":"Sum(NK Abrechnung Extension.Anteil)","excludeRowTotal":false,"excludeColumnTotal":false,"ruleFor":"parent","columnRuleFor":"child","webUrlBasedOn":"","linkIcon":true,"colorCodeBasedOn":"","colorCodeColorFor":"font","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":false,"isTextGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"background","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","applyClassificationToCharts":true,"enableCustom":false,"includeNull":false,"textGroupName":"segmentation","targetValues":[{"id":"-818294882","from":"MIN","to":-5435.85,"fromPercentage":-140,"toPercentage":-61,"color":"rgba(0,128,0,0.8)"},{"id":"-158521495","from":-5435.85,"to":1833.3,"fromPercentage":-61,"toPercentage":19,"color":"rgba(217,179,0,0.8)"},{"id":"-1736442945","from":1833.3,"to":"MAX","fromPercentage":19,"toPercentage":100,"color":"rgba(230,108,55,0.8)"}],"targetValueType":"percent","iconGroupValues":[{"id":"1393216803","from":"MIN","to":-5435.85,"fromPercentage":-140,"toPercentage":-61,"color":"rgba(0,128,0,0.8)","iconConfig":{"icon":"cross","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-1350890919","from":-5435.85,"to":1833.3,"fromPercentage":-61,"toPercentage":19,"color":"rgba(217,179,0,0.8)","iconConfig":{"icon":"alert","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-1899658062","from":1833.3,"to":"MAX","fromPercentage":19,"toPercentage":100,"color":"rgba(230,108,55,0.8)","iconConfig":{"icon":"tick","isCustomIcon":false,"customIconBase64Value":""}}],"iconGroupName":"accept","textGroupValues":[{"id":"-58148598","from":"MIN","to":-8343.51,"fromPercentage":-140,"toPercentage":-93,"color":"#D64550","text":"VERY LOW","iconConfig":{"icon":"cross","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-1794637672","from":-8343.51,"to":-3982.02,"fromPercentage":-93,"toPercentage":-46,"color":"#e3828a","text":"LOW","iconConfig":{"icon":"alert","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-1885880060","from":-3982.02,"to":379.47,"fromPercentage":-46,"toPercentage":1,"color":"#f8ca50","text":"MEDIUM","iconConfig":{"icon":"tick","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-1019518460","from":379.47,"to":4740.96,"fromPercentage":1,"toPercentage":48,"color":"#00CC00","text":"HIGH","iconConfig":{"isCustomIcon":false,"customIconBase64Value":""}},{"id":"1830387838","from":4740.96,"to":"MAX","fromPercentage":48,"toPercentage":100,"color":"#008000","text":"VERY HIGH","iconConfig":{"isCustomIcon":false,"customIconBase64Value":""}}],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"percent","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","operator":">","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","toMeasure":"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","measureMembers":[{"label":"All","key":"allSelected"}],"measureMembersObj":{"allSelected":true},"periodOperator":">"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","gradientColorMin":"#a0d1ff","gradientColorMax":"#41A4FF","gradientValueMax":null,"gradientValueMin":null,"positiveColor":"#41A4FF","negativeColor":"#a0d1ff","gradientPlacement":"left","lineColor":"#666666","lineStyle":1,"isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","ratingTextColor":"#e66c37","reverseRating":false,"ranking":{"type":"topN","isPercent":false,"noOfItems":5,"topNPercent":20,"filterBy":null,"basedOn":null},"heatMapType":"columnHeatMap"},{"enabled":true,"highlightedMeasure":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","highlightedMeasureName":"CountNonNull(NK Abrechnung Extension.Anteil)","name":"1236799001","ruleType":"classification","displayName":"Icons - AC","basedOn":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","basedOnMeasureName":"CountNonNull(NK Abrechnung Extension.Anteil)","excludeRowTotal":false,"excludeColumnTotal":true,"ruleFor":"parent","columnRuleFor":"child","webUrlBasedOn":"","linkIcon":true,"colorCodeBasedOn":"","colorCodeColorFor":"font","columnRuleType":"default","classificationPosition":"left","colorScaleApplyTo":"seq","isIconGroupAltered":true,"isTextGroupAltered":false,"autoFontColor":true,"colorOnly":false,"invertColor":false,"colorScaleColorFor":"background","colorScheme":{"selectedColorScheme":"Blues","numberOfRanges":5,"colors":["#d0e1f2","#94c4df","#4a98c9","#1764ab","#08306b"],"minColor":"red","middleColor":"blue","maxColor":"green"},"classificationType":"icon","applyClassificationToCharts":true,"enableCustom":false,"includeNull":false,"textGroupName":"segmentation","targetValues":[{"id":"62679648","from":"MIN","to":-5435.88,"fromPercentage":-140,"toPercentage":-61,"color":"rgba(0,128,0,0.8)"},{"id":"1134608118","from":-5435.88,"to":1833.24,"fromPercentage":-61,"toPercentage":19,"color":"rgba(217,179,0,0.8)"},{"id":"1193095975","from":1833.24,"to":"MAX","fromPercentage":19,"toPercentage":100,"color":"rgba(230,108,55,0.8)"}],"targetValueType":"percent","iconGroupValues":[{"id":"2091071290","from":"MIN","to":"-0","fromPercentage":-140,"toPercentage":-61,"color":"#377D22","iconConfig":{"icon":"tick","isCustomIcon":false,"customIconBase64Value":""}},{"id":"1255098281","from":"0","to":"MAX","fromPercentage":19,"toPercentage":100,"color":"#A60000","iconConfig":{"icon":"alert","isCustomIcon":false,"customIconBase64Value":""}}],"iconGroupName":"accept","textGroupValues":[{"id":"-1141762062","from":"MIN","to":-8343.53,"fromPercentage":-140,"toPercentage":-93,"color":"#D64550","text":"VERY LOW","iconConfig":{"icon":"cross","isCustomIcon":false,"customIconBase64Value":""}},{"id":"-793897740","from":-8343.53,"to":-3982.06,"fromPercentage":-93,"toPercentage":-46,"color":"#e3828a","text":"LOW","iconConfig":{"icon":"alert","isCustomIcon":false,"customIconBase64Value":""}},{"id":"39079116","from":-3982.06,"to":379.41,"fromPercentage":-46,"toPercentage":1,"color":"#f8ca50","text":"MEDIUM","iconConfig":{"icon":"tick","isCustomIcon":false,"customIconBase64Value":""}},{"id":"611141652","from":379.41,"to":4740.89,"fromPercentage":1,"toPercentage":48,"color":"#00CC00","text":"HIGH","iconConfig":{"isCustomIcon":false,"customIconBase64Value":""}},{"id":"-175169049","from":4740.89,"to":"MAX","fromPercentage":48,"toPercentage":100,"color":"#008000","text":"VERY HIGH","iconConfig":{"isCustomIcon":false,"customIconBase64Value":""}}],"rankingBuckets":[],"rankingBucketsValueType":"percent","iconGroupValueType":"value","textGroupValueType":"percent","textColorFor":"font","ratingIcons":["cross","alert","tick"],"conditionalOperator":"or","conditions":[{"name":"Condition 0","basedOn":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","conditionType":"singleMeasure","valueType":"static","comparisonMeasure":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","operator":">","comparisonValue":0,"from":0,"to":100,"aggregationType":"includes","calculationType1":"value","calculationValue1":0,"calculationMeasure1":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","calculationOperator":"+","calculationType2":"measure","calculationValue2":100,"calculationMeasure2":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","dimension":"","dimensionMembers":[],"comparisonText":"","count":10,"fromMeasure":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","toMeasure":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","measureMembers":[{"label":"All","key":"allSelected"}],"measureMembersObj":{"allSelected":true},"periodOperator":">"}],"bold":false,"italic":false,"underline":false,"underlineColor":"#000000","applyTextColor":true,"color":"#FF4400","applyBackgroundColor":false,"background":"#F5F5F5","gradientColorMin":"#a0d1ff","gradientColorMax":"#41A4FF","gradientValueMax":null,"gradientValueMin":null,"positiveColor":"#41A4FF","negativeColor":"#a0d1ff","gradientPlacement":"left","lineColor":"#666666","lineStyle":1,"isIconPresent":false,"iconPosition":"left","iconColor":"#e66c37","icon":"up","iconType":"icon","isCustomIcon":false,"customIconBase64Value":"","customIconName":"","text":"","textDetailPosition":"none","shapeCount":5,"shapeColor":"#e66c37","ratingDetailPosition":"none","ratingTextColor":"#e66c37","reverseRating":false,"ranking":{"type":"topN","isPercent":false,"noOfItems":5,"topNPercent":20,"filterBy":null,"basedOn":null}}],"tempRule":null},"kpiExplorerCf":{"rules":[]},"columnSelection":false,"templateConfig":{"template":"T03","type":"ibcs"},"isInFocus":true,"manageMeasures":[{"id":"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp","label":"AC","name":"CountNonNull(NK Abrechnung Extension.Anteil)","order":0,"visible":true,"measureType":"data"},{"id":"CALC_COL_48","label":"% Cont. of AC","order":1,"visible":false,"columnType":"NUMBER_COLUMN","name":"CALC_COL_48"},{"id":"CALC_COL_36","label":"Anteil Gruppe","order":2,"visible":false,"columnType":"NUMBER_COLUMN","name":"CALC_COL_36"},{"id":"CALC_COL_55","label":"% Cont. of Total BK","order":3,"visible":true,"columnType":"NUMBER_COLUMN","name":"CALC_COL_55"},{"id":"Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp","label":"Total BK","name":"Sum(NK Abrechnung Extension.Betrag)","order":4,"visible":true,"measureType":"data"},{"id":"CALC_COL_39","label":"Anteil Total","order":5,"visible":false,"columnType":"NUMBER_COLUMN","name":"CALC_COL_39"}],"invertRows":{"valueRow":{"Fremdperiodenanteil":true,"Akonto__geleistet":true}},"resultRows":{"CAL_ROW11":true,"CAL_ROW19":true,"CAL_ROW13":true,"CAL_ROW31":true},"shouldAggregate":true,"columnMeta":{"row_label":{"width":181},"Betriebskosten Positionen Verweis.Aktiv":{},"Nebenkosten Positionen.Hierarchie":{},"NK Abrechnung Extension.Hierarchie":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":78},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":72},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":72},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":72},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":72},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":66},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Grand__Total__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":66},"Grand__Total__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"LEFT__SECTION__COL#$@Rotkorn__23__Um90a29ybiUyMDIz__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"LEFT__SECTION__COL#$@Rotkorn__23__Um90a29ybiUyMDIz__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"RIGHT__SECTION__COL#$@Grand__Total__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"RIGHT__SECTION__COL#$@Grand__Total__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":75},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":75},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__CALC_COL_26":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":59},"Grand__Total__CALC_COL_26":{"width":59},"Grand__Total__Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":69},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":69},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":59},"Grand__Total__Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Grand__Total__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Grand__Total__Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":64},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":64},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":59},"Grand__Total__Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Grand__Total__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2014__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2014__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2016__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2016__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2017__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2017__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__CALC_COL_57":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2019__CALC_COL_57":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020__CALC_COL_57":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2021__CALC_COL_57":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2022__CALC_COL_57":{"width":59},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2023__CALC_COL_57":{"width":59},"Grand__Total__CALC_COL_57":{"width":59},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2017__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2017__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2018__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2018__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2019__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2019__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2020__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2020__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2021__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2021__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2022__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2022__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2023__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ____2023__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2017__Morger__MjAxNyUyMC0lMjBNb3JnZXI____CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2017__Morger__MjAxNyUyMC0lMjBNb3JnZXI____Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2021__Familie__Schneider__MjAyMSUyMC0lMjBGYW1pbGllJTIwU2NobmVpZGVy__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2021__Familie__Schneider__MjAyMSUyMC0lMjBGYW1pbGllJTIwU2NobmVpZGVy__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2022__Familie__Hajredini__MjAyMiUyMC0lMjBGYW1pbGllJTIwSGFqcmVkaW5p__2022__CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2022__Familie__Hajredini__MjAyMiUyMC0lMjBGYW1pbGllJTIwSGFqcmVkaW5p__2022__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{}},"chartTypes":{"CALC_COL_27":"bar","Sum(NK Abrechnung Extension.Verbrauch)":"table","CALC_COL_39":"bar","Sum(NK Abrechnung Extension.Betrag)":"table","CALC_COL_36":"bar","CALC_COL_47":"waterfall","CALC_COL_55":"bar"},"gridLineCount":1,"measureAggMap":{"Sum__Nebenkosten__Abrechnungen__Verweis__Periodenanteil__U3VtKE5lYmVua29zdGVuJTIwQWJyZWNobnVuZ2VuJTIwVmVyd2Vpcy5QZXJpb2RlbmFudGVpbCk__":"avg","CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":"sum","Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":"sum","CALC_COL_36":null,"CALC_COL_39":"avg","CALC_COL_40":"avgLeaf","CALC_COL_41":"avgLeaf","CALC_COL_42":"avgLeaf","CALC_COL_44":"avgLeaf","CALC_COL_45":"avgLeaf","CALC_COL_46":"avg","CALC_COL_47":"avgLeaf","CALC_COL_48":"avgLeaf","CALC_COL_49":"avgLeaf","CALC_COL_51":"avgLeaf","CALC_COL_55":"avgLeaf"},"outliers":{"enableOutlier":false,"min":0,"max":0},"headerLabelFormat":{},"sparklineConfig":{},"displayAllCols":false,"bulletConfig":{},"stackedConfig":{},"dynamicRowIcon":true,"calcCellIcon":false,"filter":{"rules":[],"combinator":"and","not":false},"search":{"category":null,"searchString":"","tokens":[]},"ranking":{"rules":[],"othersLabel":"Others","enableOthersSuffix":false,"enableOthersCount":true,"showOthers":true},"kpiExplorer":{"showExplorer":false,"selectedMeasure":"","filterValues":{},"panelWidthMeta":{},"showKPI":{"column":{},"row":{}},"sort":{},"expanded":true,"timeInterval":[],"showTimeSlider":false,"mode":"detailed"},"absoluteSort":false,"absoluteSearch":true,"invertSettings":"value","enableDrillThrough":false,"wizardComplete":true,"expandRowLevel":null,"aggregationType":"avgLeaf","varianceInvertColumn":{},"landingPage":false,"columnExpandCollapse":{"Rebhalden__19__UmViaGFsZGVuJTIwMTk__":{"expanded":true},"Rebhalden__19__UmViaGFsZGVuJTIwMTk____2018__Rudolph__MjAxOCUyMC0lMjBSdWRvbHBo":{"expanded":true},"Rebhalden__19__UmViaGFsZGVuJTIwMTk____2023__Lux__MjAyMyUyMC0lMjBMdXg__":{"expanded":true},"Rotkorn__23__Um90a29ybiUyMDIz":{"expanded":true},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8__":{"expanded":true},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3":{"expanded":true},"Promenaden__27__UHJvbWVuYWRlbiUyMDI3__2016__Geschwend__MjAxNiUyMC0lMjBHZXNjaHdlbmQ__":{"expanded":true},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3":{"expanded":true},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2017__Morger__MjAxNyUyMC0lMjBNb3JnZXI__":{"expanded":false},"Burghalden__17__QnVyZ2hhbGRlbiUyMDE3__2022__Familie__Hajredini__MjAyMiUyMC0lMjBGYW1pbGllJTIwSGFqcmVkaW5p":{"expanded":true},"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2020":{"expanded":true}},"layoutType":"default","calculatedCells":[{"id":1,"rowId":"ROW_GROUP_1","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p","formula":"BLANK","version":2},{"id":2,"rowId":"ROW_GROUP_1","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__","formula":"BLANK","version":2},{"id":5,"rowId":"ROW_GROUP_1","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__","formula":"BLANK","version":2},{"id":6,"rowId":"ROW_GROUP_1","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp","formula":"BLANK","version":2},{"id":9,"rowId":"CAL_ROW9","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Effektive__Einheiten__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4lMjBUb3RhbCk__","formula":"BLANK","version":2},{"id":10,"rowId":"CAL_ROW9","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Effektive__Einheiten__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5FZmZla3RpdmUlMjBFaW5oZWl0ZW4p","formula":"BLANK","version":2},{"id":11,"rowId":"CAL_ROW9","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Verbrauch__Total__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2glMjBUb3RhbCk__","formula":"BLANK","version":2},{"id":12,"rowId":"CAL_ROW9","columnId":"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_X_Sum__NK__Abrechnung__Extension__Verbrauch__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5WZXJicmF1Y2gp","formula":"BLANK","version":2}],"enablePersistFilter":false,"columnGroupConfig":{},"alertFilter":[],"rowHeightsConfig":{"level":{},"row":{"Nebenkosten__Bruttolohn__inklusive__Sozialabgaben__der__Hauswartung":18,"Nebenkosten__Energiekosten__f__r__Aufw__rmung__des__Warmwassers":18,"Nebenkosten__Grundnutzungsgeb__hren__Kabelnetzbetreibern":18,"Nebenkosten__Kosten__f__r__Wasser__zum__Duschen__Kochen__etc__":18,"Nebenkosten__Lifttelefonanschlussgeb__hr":18,"Nebenkosten__Periodischer__Brennerservice__Tankrevision__KaminfegerIn":18,"Nebenkosten__Serviceabos__f__r__reine__Wartung__und__Reinigung":18,"Nebenkosten__Strom__f__r__allgemein__zug__ngliche__R__ume":18,"Nebenkosten__Strom__f__r__Pumpen__und__Brenner":18,"Nebenkosten__Unterhalt__und__Verbrauchsmaterial":18,"Nebenkosten__Verwaltungsaufwand__f__r__Beheizung__Versicherung__f__r__Heizungsanlage":18,"Nebenkosten":18,"Periodenanteil":40,"CAL_ROW7":40,"ROW_GROUP_1":40,"CAL_ROW13":40,"CAL_ROW9__empty_0":18,"CAL_ROW9":18,"CAL_ROW19":18,"Akonto__geleistet__empty_0":18,"Akonto__geleistet":18,"CAL_ROW11":40,"Fremdperiodenanteil":18,"CAL_ROW33":18,"CAL_ROW31":18,"Nebenkosten__Kosten__f__r__Brennstoff__l__Gas__oder__andere__Energie__":18,"Nebenkosten__Chemikalien__f__r__Wasseraufbereitung__und__Entkalkung":18,"Nebenkosten__Periodischer__R__ckschnitt__von__Str__uchern":18,"Nebenkosten__Schneer__umungsarbeiten":18,"Nebenkosten__Serviceabos__f__r__Kontrolle__und__Wartung":18,"Nebenkosten__Verwaltungskosten":18,"Grand__Total":31}},"summarySettings":{"rowLayout":"multi","forceMultiLine":false,"columnCount":2,"autoFit":false,"detailGridHeight":300,"detailGridHeightType":"auto","detailXPadding":10,"detailYPadding":10,"detailBreakBy":{"row":"","column":""},"showAggregation":false,"detailLayout":"table","showGroupBorder":true,"groupBorderGap":10,"groupHeaderColor":"#edebe9","groupBorderColor":"#cccccc","groupBorderThickness":1,"summaryHeader":{"elements":[]},"summaryFooter":{"elements":[]},"summaryGlobalHeader":{"elements":[]},"showSummaryHeader":true,"showSummaryFooter":true,"showSummaryGlobalHeader":false,"summaryHeaderHeight":30,"summaryFooterHeight":30,"summaryGlobalHeaderHeight":180,"masterRowExpandCollapseConfig":{},"multiColumn":{"enabled":false,"cols":[]},"categoryBreak":"none","columnSpacing":10,"summaryPage":{"enabled":false,"position":"hide"},"listView":true,"drillDownData":[],"syncScroll":true},"readViewToolbar":{"show":true,"selection":true,"showTooltip":true,"readViewToolbarMode":"auto","showSearch":false,"showReportFilter":true,"showToastMessage":true,"sortOnClick":false,"showFloatingToolbar":false},"showChildCount":false,"showCategorySign":true,"showCategorySignPositive":false,"hideResultSign":false,"subTotalHeight":10,"grandTotalHeight":-3,"exportSettings":{"exportType":"matrix","scaling":"0","scaleRatio":-1,"pageSize":"a4","columnWidth":"normal","orientation":"l","margin":"md","logo":{"filename":"","base64":"","width":60,"height":30},"title":"","subTitle":"","displaydate":true,"pageNumber":true,"pageLabel":"1","footerNote":"dynamic","displayHeaderFooter":"everyPage","fileName":"","pdfFont":"inforiversans","printApproach":"rowFirst"},"exportExcelSettings":{"exportType":"matrix","logo":{"filename":"","base64":"","width":60,"height":30},"title":"","subTitle":"","footerNote":"","hierarchyView":"visualView","includeComments":true,"fileName":""},"ruler":{"enabled":true,"disabled":{"state":false,"prevEnabledState":null},"activeSummaryGroup":null},"recentColors":["#cccccc","#ffffff","#4e89f4","#ad5129","#00b300","#377D22","#A60000"],"frequentColors":["#4e89f4","#8DB901","#FB0209"],"formatConfig":{"row":{"Akonto__geleistet":[{"order":84,"format":{"13":"none"}}],"Periodenanteil":[{"order":10,"format":{"10":true}}],"Nebenkosten":[{"order":82,"format":{"13":"none"}}],"Nebenkosten__Verwaltungskosten":[],"Nebenkosten__Bruttolohn__inklusive__Sozialabgaben__der__Hauswartung":[],"Nebenkosten__Erneuerungsfond":[],"Nebenkosten__Geb__udeversicherung":[],"Nebenkosten__Kosten__f__r__Brennstoff__l__Gas__oder__andere__Energie__":[],"Nebenkosten__Kosten__f__r__Wasser__zum__Duschen__Kochen__etc__":[],"Nebenkosten__Periodischer__Brennerservice__Tankrevision__KaminfegerIn":[],"Nebenkosten__Rasenm__hen__Bew__ssern__bei__Trockenheit":[],"Nebenkosten__Reparaturen__Ersatzanschaffungen__Amortisation__der__Heizungsanlage":[],"Nebenkosten__Strom__f__r__allgemein__zug__ngliche__R__ume":[],"Nebenkosten__Unterhalt__und__Verbrauchsmaterial":[],"Verrechnungshonorar__3__":[],"Grand__Total":[],"CAL_ROW7":[],"CAL_ROW38":[{"order":80,"format":{"10":true}}],"CAL_ROW33":[{"order":83,"format":{"13":"none"}}]},"column":{"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_bullet_975224979":[{"order":59,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_stacked_-1831706473":[{"order":63,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_stacked_-2028921232":[{"order":64,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_stacked_1069227907":[{"order":69,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_bullet_1571914691":[{"order":70,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_stacked_undefined":[{"order":71,"format":{}},{"order":73,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_bullet_-593019583":[{"order":72,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_bullet_-1322946176":[{"order":74,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018_bullet_undefined":[{"order":76,"format":{}},{"order":77,"format":{}}],"Rotkorn__23__Um90a29ybiUyMDIz__2018__Aiello__MjAxOCUyMC0lMjBBaWVsbG8____2018__CALC_COL_36":[{"order":125,"format":{"5":"#ffffff"}},{"order":138,"format":{"5":"#cccccc"}},{"order":139,"format":{"5":"#cccccc"}},{"order":140,"format":{"5":"#cccccc"}},{"order":141,"format":{"5":"#cccccc"}},{"order":142,"format":{"5":"#ffffff"}}]},"rowDimension":{},"cell":{"Grand__Total#$@Rebhalden__19__UmViaGFsZGVuJTIwMTk____2018__Rudolph__MjAxOCUyMC0lMjBSdWRvbHBo__2018__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":[],"Grand__Total#$@Rebhalden__19__UmViaGFsZGVuJTIwMTk____2018__Rudolph__MjAxOCUyMC0lMjBSdWRvbHBo__2018__Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":[],"Akonto__geleistet#$@Rebhalden__19__UmViaGFsZGVuJTIwMTk____2018__Rudolph__MjAxOCUyMC0lMjBSdWRvbHBo__2018__Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":[]},"measure":{"Sum(Betriebskosten Konten Verweis.Anteil)":[],"Sum(Nebenkosten Abrechnungen.Akonto geleistet)":[],"Sum(Nebenkosten Abrechnungen.Verrechnungshonorar 3%)":[],"Sum(Betriebskosten Konten Verweis.Betrag)":[],"Sum(NK Abrechnung Extension.Anteil)":[],"Sum(NK Abrechnung Extension.Betrag)":[{"order":81,"format":{"13":"none"}},{"order":89,"format":{"25":1}},{"order":90,"format":{"32":true}},{"order":91,"format":{"51":"perc"}},{"order":92,"format":{"51":"label"}},{"order":93,"format":{"16":12,"41":0}}],"Sum(Nebenkosten Abrechnungen Verweis.Periodenanteil)":[{"order":75,"format":{"10":true}}],"Sum(NK Abrechnung Extension.Verbrauch Total)":[],"CALC_COL_24":[{"order":41,"format":{"11":3}},{"order":42,"format":{"11":2}}],"CALC_COL_25":[],"CALC_COL_27":[{"order":43,"format":{"10":true}},{"order":44,"format":{"25":1}},{"order":45,"format":{"32":true}},{"order":46,"format":{"32":false}},{"order":47,"format":{"32":true}},{"order":48,"format":{"51":"perc"}},{"order":49,"format":{"51":"label"}},{"order":50,"format":{"51":"perc"}},{"order":51,"format":{"51":"label"}},{"order":52,"format":{"30":false}},{"order":53,"format":{"30":true}},{"order":54,"format":{"28":"hatched"}},{"order":55,"format":{"28":"outlined"}},{"order":56,"format":{"28":"solid"}},{"order":57,"format":{"28":"outlined"}}],"Sum(NK Abrechnung Extension.Verbrauch)":[{"order":58,"format":{"25":1}},{"order":60,"format":{"25":2}},{"order":61,"format":{"25":1}},{"order":62,"format":{"16":12,"41":0}}],"Sum(NK Abrechnung Extension.Effektive Einheiten)":[{"order":65,"format":{"11":1}},{"order":66,"format":{"11":0}}],"Sum(NK Abrechnung Extension.Effektive Einheiten Total)":[{"order":67,"format":{"11":1}},{"order":68,"format":{"11":0}}],"CountNonNull(NK Abrechnung Extension.Anteil)":[{"order":86,"format":{"13":"none"}}],"CALC_COL_36":[{"order":79,"format":{"10":true}},{"order":95,"format":{"25":1}},{"order":96,"format":{"44":true}},{"order":97,"format":{"44":false}},{"order":98,"format":{"32":true}},{"order":99,"format":{"32":false}},{"order":100,"format":{"44":true}},{"order":106,"format":{"28":"outlined"}},{"order":107,"format":{"28":"solid"}},{"order":108,"format":{"25":5}},{"order":109,"format":{"25":2}},{"order":110,"format":{"25":1}},{"order":111,"format":{"25":2}},{"order":115,"format":{"25":5}},{"order":116,"format":{"53":true}},{"order":117,"format":{"53":false}},{"order":118,"format":{"28":"outlined"}},{"order":119,"format":{"28":"hatched"}},{"order":120,"format":{"28":"solid"}},{"order":121,"format":{"32":true}},{"order":122,"format":{"32":false}},{"order":123,"format":{"30":false}},{"order":124,"format":{"30":true}},{"order":130,"format":{"53":true}},{"order":131,"format":{"53":false}},{"order":132,"format":{"25":2}},{"order":133,"format":{"25":5}},{"order":134,"format":{"25":2}},{"order":137,"format":{"25":1}},{"order":143,"format":{"25":5}},{"order":144,"format":{"53":true}},{"order":145,"format":{"54":5}},{"order":146,"format":{"54":6}},{"order":147,"format":{"54":7}},{"order":148,"format":{"54":8}},{"order":149,"format":{"54":9}},{"order":150,"format":{"54":10}},{"order":151,"format":{"54":11}},{"order":152,"format":{"54":11}},{"order":153,"format":{"54":12}},{"order":154,"format":{"54":13}},{"order":155,"format":{"54":12}},{"order":156,"format":{"54":11}},{"order":157,"format":{"54":10}},{"order":166,"format":{"41":0.21}},{"order":167,"format":{"41":0.22}},{"order":168,"format":{"41":0.23}},{"order":169,"format":{"41":0.24}},{"order":170,"format":{"41":0.25}},{"order":171,"format":{"41":0.25}},{"order":172,"format":{"41":0.26}},{"order":173,"format":{"41":0.27}},{"order":174,"format":{"41":0.29}},{"order":175,"format":{"16":12,"41":0.3}},{"order":176,"format":{"41":0.31}},{"order":177,"format":{"41":0.32}},{"order":178,"format":{"41":0.33}},{"order":179,"format":{"41":0.34}},{"order":180,"format":{"41":0.33}},{"order":181,"format":{"41":0.32}},{"order":182,"format":{"41":0.31}},{"order":183,"format":{"41":0.31}},{"order":184,"format":{"41":0.3}},{"order":185,"format":{"16":12,"41":0.29}},{"order":186,"format":{"41":0.28}},{"order":187,"format":{"41":0.27}},{"order":188,"format":{"41":0.27}},{"order":189,"format":{"41":0.26}},{"order":190,"format":{"41":0.25}},{"order":191,"format":{"41":0.24}},{"order":192,"format":{"41":0.23}},{"order":193,"format":{"41":0.24}},{"order":194,"format":{"41":0.25}},{"order":195,"format":{"41":0.26}},{"order":196,"format":{"41":0.27}},{"order":197,"format":{"41":0.28}},{"order":198,"format":{"41":0.29}},{"order":199,"format":{"41":0.28}},{"order":200,"format":{"41":0.27}},{"order":201,"format":{"41":0.26}},{"order":202,"format":{"41":0.25}},{"order":203,"format":{"41":0.24}},{"order":204,"format":{"41":0.23}},{"order":205,"format":{"41":0.22}},{"order":206,"format":{"41":0.21}},{"order":207,"format":{"41":0.2}},{"order":208,"format":{"41":0.2}},{"order":209,"format":{"28":"outlined"}},{"order":210,"format":{"28":"hatched"}},{"order":211,"format":{"28":"solid"}},{"order":212,"format":{"44":false}},{"order":213,"format":{"30":false}},{"order":214,"format":{"30":true}},{"order":215,"format":{"32":true}},{"order":216,"format":{"32":false}},{"order":217,"format":{"32":true}},{"order":218,"format":{"32":false}}],"CALC_COL_39":[{"order":85,"format":{"10":true}},{"order":87,"format":{"25":1}},{"order":88,"format":{"32":true}},{"order":101,"format":{"32":false}},{"order":102,"format":{"44":true}}],"CALC_COL_40":[{"order":94,"format":{"10":true}}],"CALC_COL_47":[{"order":103,"format":{"10":true}},{"order":112,"format":{"23":2}},{"order":113,"format":{"23":1}}],"CALC_COL_48":[{"order":104,"format":{"10":true}}],"CALC_COL_49":[{"order":105,"format":{"10":true}}],"CALC_COL_51":[{"order":114,"format":{"10":true}}],"CALC_COL_55":[{"order":126,"format":{"10":true}},{"order":127,"format":{"25":2}},{"order":128,"format":{"25":5}},{"order":129,"format":{"44":true}},{"order":135,"format":{"53":true}},{"order":136,"format":{"53":false}},{"order":158,"format":{"53":true}},{"order":159,"format":{"54":5}},{"order":160,"format":{"54":6}},{"order":161,"format":{"54":7}},{"order":162,"format":{"54":8}},{"order":163,"format":{"54":9}},{"order":164,"format":{"54":9}},{"order":165,"format":{"54":10}}]},"formatSize":219},"layoutSizes":{"tableWidth":75,"chartWidth":150,"labelWidth":120,"bulletWidth":300,"maximumChartWidth":200,"isMaximumChartWidthAllowed":false,"preferedWidthSelection":"measure","isResponsive":false},"pinnedRowIds":["CAL_ROW13"],"pinnedColIds":[],"virtualRoleColumnMap":{},"rowGroupConfig":{},"columnHierarchyReorder":{"colOrderConfig":{},"colOrderConfigMeta":{}},"rowLabelMeta":{"true":"Nebenkosten"},"hiddenRows":[],"toolbar":{"currentTab":"","isPinned":true,"showTabContent":true,"showMinimalView":false,"toolbarTheme":"light","showOnHover":false,"enableHoverToolbar":true,"readViewPin":true,"showFloatingToolbar":true,"setCanvasResize":false,"showMinimalTabEditMode":false,"backupState":{"showMinimalView":false,"isPinned":true,"showTabContent":true,"showOnHover":false,"enableHoverToolbar":true,"showMinimalTabEditMode":false}},"warningModal":{"show":false,"message":"","autoClose":true,"showLoader":false,"showClose":true},"showGripper":true,"showComments":true,"showHeaderFooter":true,"urlMetaConfig":{"hasURL":false,"hasImg":false,"urlColId":"","urlColIndex":null},"pbiThemeColor":{"rowLevelTheme":{"0":"#118DFF","1":"#12239E","2":"#E66C37"},"measureLevelTheme":{"0":"#118DFF","1":"#12239E","2":"#E66C37","3":"#6B007B","4":"#E044A7","5":"#744EC2","6":"#D9B300","7":"#D64550","8":"#197278","9":"#1AAB40","10":"#15C6F4"}},"labelColIndex":null,"hierarchy":{"raggedHierarchy":true,"hideBlanks":"vc","hideZeros":false,"unbalancedHierarchy":"off"},"totalsDisplay":{"showSubTotalsAsTable":false,"showVarSubTotalsAsTable":false,"showTotalAsTable":true,"showVarTotalAsTable":false,"showColumnGTAsTable":true,"advancedSteppedLayout":false,"removeSingleChildren":true},"rowAutoGroupConfig":{"ruleName":"none"},"chartStyles":{"variancePin":"square","showDataLabel":true,"isBarOverlap":false},"autoFitOptions":{"autoFit":false,"lockColumnWidth":true,"wrapCols":false,"uniformColumnWidth":{"enabled":false,"width":null}},"readViewConfig":{"home":{"navigation":true,"alignment":true,"style":true,"number":true,"chart":true,"analyze":true,"notes":true,"setup":true},"advanced":{"pagelayout":true,"compare":true,"cells":true,"measure":true,"monitor":true,"rows":true,"column":true,"simulate":true,"dataInput":true,"scenario":true},"export":{"pdf":true,"excel":true,"visual":true,"copyToClipboard":true,"schedule":true,"writeBack":false},"dataEntry":{"scenario":false,"audit":false,"comment":false,"action":false,"column":false,"display":false},"advancedTabMenu":{"rowColumnConfig":true},"enterprise":{"writeBack":true,"schedule":true,"layout":true,"breaks":true,"table":true,"reportPlus":true},"scenario":{"scenario":false,"export":false,"writeBack":false,"analyze":false,"annotate":false,"monitor":false,"reset":false,"modifiedByUser":false}},"totalCustomTitle":{"grandTotalTitle":"All","columnGrandTotalTitle":"Grand Total","totalColumnSuffix":"Total","steppedSubTotalTitle":"none","steppedSubTotalText":"Total","splitTotalRowSuffix":"Total"},"scaleDelta":{"height":0,"width":0,"scale":1},"hideRowChildren":[],"hideExpandLevel":{},"commentSettings":{"rowLevelComments":false,"expandRowLevelComments":false,"rollUpComments":true},"rulerMeta":{"width":20,"showNumbers":false,"loading":false},"commonRunTimeProps":{"showBrokenImage":false},"hideHeader":{"hierarchyHeader":false,"separator":" - "},"measureAttributes":{"Sum__NK__Abrechnung__Extension__Anteil__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":90},"Sum__NK__Abrechnung__Extension__Betrag__U3VtKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5CZXRyYWcp":{"width":82},"CALC_COL_22":{"width":150},"CALC_COL_24":{"width":92},"stacked_-1831706473":{"width":139},"stacked_-2028921232":{"width":133},"stacked_1069227907":{"width":200},"CountNonNull__NK__Abrechnung__Extension__Anteil__Q291bnROb25OdWxsKE5LJTIwQWJyZWNobnVuZyUyMEV4dGVuc2lvbi5BbnRlaWwp":{"width":80},"CALC_COL_47":{"width":150}},"powerBiTheme":{"isHighContrast":false,"foreground":null,"background":null,"foregroundSelected":null,"hyperlink":null,"themeType":null},"quickFilter":{"rules":[],"combinator":"and","not":false},"selectionDataNote":{"enable":true,"aggregateOption":{"sum":true,"avg":true,"min":false,"max":false,"count":true}},"currentThemeType":{"themeType":"trafficlights"},"enableMeasureInRows":false,"enableMeasureInCols":false,"quickAccessIcons":{"exportExcel":true,"undo":true,"bestFit":true,"redo":true,"writeback":true,"smartAnalysis":false,"exportPdf":false,"rails":true,"reset":true,"aggregation":false},"columnHierarchyHeader":{"Liegenschaften.Liegenschaft":{"height":25},"Mietverträge.Name":{"height":25},"Nebenkosten Abrechnungen Verweis.Abrechnungsperiode Ende.Variation.Datumshierarchie.Jahr":{"height":25}},"customColumnCategory":{"enable":false,"categoryItemCount":12,"prefix":"Category Item ","suffix":""},"showSubtotalLevels":{},"customInputColumn":{},"storedColumnTooltip":false,"diagnose":true,"viewConfig":{"views":[],"selectedView":null,"showViewSwitcher":true},"repeatLevelLabels":{},"hideEmptyCols":true,"columnAsTable":{"dimensionId":null},"contextMenu":true,"emptyRows":{"Verrechnungshonorar__3__":1,"Akonto__geleistet":1,"CAL_ROW9":1},"toastSettings":{"disableToasts":false},"storedColumn":{},"dataReductionRowCount":500,"dataReductionColCount":60,"dataReductionSettings":{"userOverride":false},"scenarioSettings":{"showAllScenarios":false,"showScenarioTabs":false},"simulationSettings":{"varianceSettings":[],"showVariance":true,"showSimulation":true},"version":{"columnAsMeasure":false,"level":0},"writebackColumnMapping":{"formValues":{"datasetId":"","workspaceId":"","datasetTableName":"","datasetKeyColumnName":"","renamedWBIdColumn":"","mappingColumns":[{"datasetColumnName":"","writebackColumnName":""}]},"formErrors":{"datasetId":"","datasetTableName":"","datasetKeyColumnName":"","renamedWBIdColumn":"","mappingColumns":[null]},"columnMappingError":null,"openAdditionColumnModal":false,"modalTitle":"Additional Column Configuration","datasetLoading":false,"showDatasetDropdown":false,"isSubmitting":false,"warning":{"title":"Additional Column Configuration","message":"","show":false},"keyColumnsForAllAdditionalColumns":[],"additionalColumnMappings":[],"dateAdditionalColumnMapping":null,"openDateAdditionalColumnModal":false,"dateFormValues":{"dateKeyColumnName":"","defaultYear":"2023","isCurrentYear":true}},"rollupNotes":true,"scenarios":[],"annotateMarker":{"toggle":false,"markerData":null},"fiscalMonth":0},"csvOptions":{"rows":["NK Abrechnung Extension.Hierarchie","NK Abrechnung Extension.Nebenkostengruppe (from Betriebskosten Position)"],"columns":["Liegenschaften.Liegenschaft","Mietverträge.Name","Nebenkosten Abrechnungen Verweis.Abrechnungsperiode Ende.Variation.Datumshierarchie.Jahr","NK Abrechnung Extension.Betriebskosten Abrechnung"],"rolesMap":{},"typesMap":{},"labelMap":{"NK Abrechnung Extension.Hierarchie":"Hierarchie","NK Abrechnung Extension.Nebenkostengruppe (from Betriebskosten Position)":"NK Gruppe","Liegenschaften.Liegenschaft":"Liegenschaft","Mietverträge.Name":"Mietvertrag","Nebenkosten Abrechnungen Verweis.Abrechnungsperiode Ende.Variation.Datumshierarchie.Jahr":"Jahr","NK Abrechnung Extension.Betriebskosten Abrechnung":"Betriebskosten Abrechnung","CountNonNull(NK Abrechnung Extension.Anteil)":"AC","Sum(NK Abrechnung Extension.Betrag)":"Total BK"},"ac_roles":["CountNonNull(NK Abrechnung Extension.Anteil)","Sum(NK Abrechnung Extension.Betrag)"],"pl_roles":[],"py_roles":[],"fc_roles":[],"om_roles":[]},"metadata":{"measures":{"AC":[{"label":"Summe von Anteil","name":"CountNonNull(NK Abrechnung Extension.Anteil)","role":"AC"},{"label":"Total BK","name":"Sum(NK Abrechnung Extension.Betrag)","role":"AC"}]},"columns":[{"id":"Liegenschaften.Liegenschaft","label":"Liegenschaft"},{"id":"Mietverträge.Name","label":"Mietvertrag"},{"id":"Nebenkosten Abrechnungen Verweis.Abrechnungsperiode Ende.Variation.Datumshierarchie.Jahr","label":"Jahr"},{"id":"NK Abrechnung Extension.Betriebskosten Abrechnung","label":"Betriebskosten Abrechnung"}],"rows":[{"id":"NK Abrechnung Extension.Hierarchie","label":"Hierarchie"},{"id":"NK Abrechnung Extension.Nebenkostengruppe (from Betriebskosten Position)","label":"NK Gruppe"}]}} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment