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.

What can we help you with?

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

Formula of Average of Custom field

2 comments

  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Stephen

    Hi Akira, thanks sharing your feedback in such detail. It really helps us understand your set up 👍
     
    By looking at the screenshot it seems like only subtasks from the Task 1 are being calculated in the field you've highlighted. This is likely due to subtasks from the other Tasks (2, 3) have not been tagged in the parent Project/Folder. By default subtasks only have Ghost Tags that provide, at a glance information, about the subtask's parent, but you need to add the Folder to the subtasks so they 'live' in that Folder. 
     
    Can you try adding the subtasks to the parent Folder and see if this helps update the calculations?
     
    Any questions, please let me know!
    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Akira Kuragami

    Hi Stephen,

    Thank you for your advice.

    I guess you might not understand my request correctly.

    I was talking about Project-X as Parent Project or Folder.

    And I changed Task Names as below because I used same task names in different Parent tasks.

    Please see the below.

     

    1) The total average of Parent project, S-Project1, is correct. (5+20+10=35/3=11.67%)

    2) The total average of Task1 & Task2 are not calculated because both are "Task". ( It is not "Project".)

      *** It is the best way that the total average is calculated even if the parent is "Task", but I understood it is

           the current specification that the total average is not calculated if the parent is "Task".

    3) So, I think that Total Average of Project-X should be 18.81% = (10 + 20 + 30 + 10 + 20 + 30 + 11.67) / 7

         because all tasks are tagged in Project-X. 

         Because the result of calculation seems incorrect if user collapses Sub-Project like below.

    Could you understand the meaning of my request?

     

    Akira IT manager

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Formula of Average of Custom field
[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.