Issue in Subtotal
Hello everyone, Quick question about P&L reports: When calculating revenue and costs, I'm finding that the subtotals for each label aren't reflecting the correct values. For instance, if revenue is $500 and EBIDTA is -$100, the subtotal for EBIDTA shows -$100 instead of the remaining $400. Any tips on how to fix this? Thanks in advance for any advice! Revenue_minus_EBITDA = VAR RevenueAmount = CALCULATE ( SUM('FINANCE_WORKING'[REV_AMT]), FILTER ( 'INTEGRATED_PROFIT & LOSS', 'INTEGRATED_PROFIT & LOSS'[Label] = "Revenue" ) ) VAR EBITDAAmount = CALCULATE ( ABS(SUM('FACT_FINANCE'[REV_AMT])), FILTER ( 'INTEGRATED_PROFIT & LOSS', 'INTEGRATED_PROFIT & LOSS'[Label] = "EBITDA" ) ) VAR EBITAAmount = CALCULATE ( ABS(SUM('FACT_FINANCE'[REV_AMT])), FILTER ( 'INTEGRATED_PROFIT & LOSS', 'INTEGRATED_PROFIT & LOSS'[Label] = "EBITA" ) ) VAR PBTAmount = CALCULATE ( ABS(SUM('FACT_FINANCE'[REV_AMT])), FILTER ( 'INTEGRATED_PROFIT & LOSS', 'INTEGRATED_PROFIT & LOSS'[Label] = "PBT" ) ) RETURN RevenueAmount -EBITDAAmount - EBITAAmount - PBTAmount /* Current Label. Label Revenue Revenue Revenue Revenue Revenue Revenue EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITDA EBITA EBITA PBT PBT PBT PBT