What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Calculating Value based on duration

2 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Anna Wallace

    Hi Mike,

    I think it would help to see an example of what you are talking about. Could you take a screenshot of the values in your workspace and the strange numbers you ended up with?ย 

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Mike Williams

    Hi Not a problem

    This is an example of what i'm working on.ย  So my site manager in the example is on a 2 day a week contract for the demo part of the job.ย  a 5 day per week contract for the fit out and a 2 day a week contract for the wind down.ย  The Handy man is on a 3 day a week contract.

    This is just an example. of what id like to do.ย  i'd like to work out how many days im paying them and auto change that amount if i change the project durations.ย  As you can see i don't get a usable number in the working weeks columb. i also cant see a way to get the data out of duration format.ย  so i can multiply it by daily or weekly rates.

    Working weeks columb is currently a formula that does [duration] / 5 ( i have tried both 5 and 7 and not got a usable number)

    DPW should be the contract multiplayer for number of days paid per will. or place holder of 1 if we are using a weekly rate.......

    Working Days paid formula - [DPW]*[Working Weeks]ย 

    Then i would take that and multiply it by daily rate column not shown as i can't make the first part work.

    This is something i've done in other project management softwares i have used. or in excel.

    m

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Calculating Value based on duration
[this list is visible for admins and agents only]

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.