¿Con qué podemos ayudarte?

Por ejemplo Diagramas de Gantt, Crear tareas, Compartir carpetas

Calculating Value based on duration

2 comentarios

  • 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
    Acciones de comentarios 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
    Acciones de comentarios Permalink

Iniciar sesión para dejar un comentario.

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.