+ Reply to Thread
Results 1 to 1 of 1

Disable calculated (sub)total

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    8

    Disable calculated (sub)total

    Hi,

    I am facing problem with calculated fields and subtotals. I use (PowerPivot) calculated measure to calculated tax max(0;income*tax rate) = if income is lower than 0, then tax to pay is 0. It works fine for each individual company but it is wrong in subtotal because calculates aggregate income instead of summing each tax.

    Example:

    Tax rate is 20%
    Company | Income | Tax
    A | 10 | 2
    B | 5 | 1
    C | -25 | 0
    Total | -5 | 0

    So instead of 3 (2+1+0) it gives me 0 [max(0;-5*0.2)]

    Does anyone have any idea how to solve this problem? The table is constructed by PowerPivot and calculated measure so it may have certain limitations (or advantages).

    Thanks
    Last edited by snakeCZ; 06-19-2017 at 10:19 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculated Field as Row Total ?
    By amphinomos in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2014, 09:38 AM
  2. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  3. Calculated Field (?) in Sub Total?
    By amsnss in forum Excel General
    Replies: 0
    Last Post: 01-10-2012, 11:48 AM
  4. How do I calculated total hours per week
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  5. How do I calculated total hours per week
    By FrankF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  6. [SOLVED] How do I calculated total hours per week
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  7. [SOLVED] How do I calculated total hours per week
    By FrankF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  8. How do I calculated total hours per week
    By FrankF in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1