Remaining Percentage & Exceeding % Calculation

  • Hi Team,


    I want to calculate the remaining % and the Exceeding % for the Target Achievement %.


    I have the Actual Number and the Target Total For one group, i am using Actual/Target to calculate the Target Achievement %.


    But i also want to calculate the Remaining % and the Exceeding %.


    The Target % is 50%. I want to know how much is the Remaining % to reach 50% and also the Exceeding %, means if it crosses 50% how much it has exceeded, whether 20%, 30%.


    But there will be 0% also, i want to display only the Positive signs, if it is 50-60 the result will be -10 and i want that to be shown in exceeding % {example}


    Please help

  • Re: Remaining Percentage & Exceeding % Calculation


    The three values needed are Actual, Target, and Target%.


    Remaining formula:
    =MAX(0,Target% - Actual/Target)


    Exceeding formula:
    =MIN(0,Actual/Target - Target%)

    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."