Question re subtracting numbers based on priority established

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Question re subtracting numbers based on priority established

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Question re subtracting numbers based on priority established

     
    Hi Guys

    I'm not too sure how to phrase this question so I'll just show you an example of what I have:

    A B C D E F G H I
    Priority 1 Priority 2 Priority 3 Total Claim To be subtracted Updated 1 Updated 2 Updated 3 Updated Claim
    10 10 10 30(Sum A,B,C) 15 0 5 10 15
    20 20 20 60(Sum A,B,C) 40 0 0 20 20

    EDIT: I have just realized how hard this is to read on screen so I just attached a picture of what I mean. The yellow highlighted cells are the ones I need help formulating: http://imgur.com/a/jRnXG


    Essentially I have a total claim, which is made up of a number of smaller claims which have a certain order of Priority.

    Now I have a number to be subtracted from the total claim, but it has to be subtracted in the order of priorities stated. I then want an updated balance of all priorities and total claim.

    Kind of like a waterfall, where I want to take all the money out of priority 1 first, before moving onto priority 2 etc etc.

    Any help with this would be much appreciated!
    Last edited by tonic1; Mar 20th, 2017 at 09:36 PM.

  2. #2
    Board Regular FDibbins's Avatar
    Join Date
    Feb 2013
    Location
    Duncansville, PA USA
    Posts
    6,639
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question re subtracting numbers based on priority established

    Copy/paste sometimes doesn't quite come out as expected here :9 Is this more or less what your table looks like?
    A
    B
    C
    D
    E
    F
    G
    H
    1
    priority1 priority2 priority3 Tot claim to be sub'd Updated1 Updated2 Updated3 Updated claim
    2
    10
    10
    10
    15
    0
    5
    10
    15
    3
    20
    20
    20
    40
    0
    0
    20
    20


    If so, can you explain what you want and how you arrive at that please?

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    Regards

    Ford

  3. #3
    New Member
    Join Date
    Nov 2015
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Question re subtracting numbers based on priority established

      
    Hi FDibbins

    Thank you so much for your reply!

    Sorry it's a little hard for me to explain - basically every row is a different employee.

    Each employee is entitled to a payout which is broken up into priorities (1,2 and 3). So if you add all the priorities 1-3 you will get the total amount entitled to that employee.

    Now we have had something come up where a number is to be taken out of the employee entitlements. Ie. we are reducing the total employee entitlements, however, because it is split into 3 priority funds, we first want to reduce the priority fund 1 to 0, and before reducing the priority fund 2 to 0 and so on.

    So in the 2nd row example, your total claim is 30 (made up of 10 in each priority fund).

    We now have to subtract 15 from the total claim.

    Since there is only 10 in the priority fund 1, we subtract the whole 10 -> now the updated Priority fund 1 shows 0

    Then there is 5 left to subtract, we subtract that from priority fund 2 -> Now the updated Priority fund 2 shows 5

    As there is nothing left to subtract, Priority fund 3 stays the same.

    I hope that all makes sense.

    Thank you so much for your help!

    Quote Originally Posted by FDibbins View Post
    Copy/paste sometimes doesn't quite come out as expected here :9 Is this more or less what your table looks like?
    A
    B
    C
    D
    E
    F
    G
    H
    1
    priority1 priority2 priority3 Tot claim to be sub'd Updated1 Updated2 Updated3 Updated claim
    2
    10
    10
    10
    15
    0
    5
    10
    15
    3
    20
    20
    20
    40
    0
    0
    20
    20


    If so, can you explain what you want and how you arrive at that please?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com