Calculation problem

Follow

Luis Diego Flores

• November 27, 2014 23:53

I have a HelpDesk app, I configured multiple categories (Status= To Do, In progress, On Hold, Open, Completed, etc), and I want to caculate the (Completed - all the rest) so I can know how many tickets I need to complete which will be something like Overall count = Completed - all the others, I assume, how can I do this? I want to estimate how much work is left to complete.
Thank you

0

• 

  Martijn Snels

  • November 28, 2014 09:10

  @All of ... will give you an array of the values which you can use.

  -1

  Comment actions Permalink
• 

  Martijn Snels

  • November 28, 2014 11:48

  Hi Luis, sure. The calculation field support javascript which means you can use the array of the values to calculate the amount of each status.

  -1

  Comment actions Permalink
• 

  Luis Diego Flores

  • November 28, 2014 11:51

  Not sure I follow.
  I need to do something like "overall count — completed tasks". I have a category field with inline values <Not started, in progress, completed>, or could it be something like "Real count= Not started + in progress +value3", how do I write the formula? and I assume is using a calculation field, right? Make sense?

  0

  Comment actions Permalink

Please sign in to leave a comment.