Skip to Main Content
127 VOTE
Status Shipped
Categories Reports
Created by Matt Case
Created on Dec 16, 2016

Calculation Custom Field Type

The use case is that you create a custom table for storing financial/budgeting type data for a project. You add a number custom field for "Planned Spend" and another number custom field for "Actual Spend". The desire is to have another calculated field named "Spend Delta" that would be derived based on a calculation of "Planned Spend" - "Actual Spend" which would be specified as part of the "Calculation" type properties. Similarly, you might want to have a derived custom field that displays the % of Budget Spent so the custom field properties would allow you to specify the equation is "Actual Spend"/"Planned Spend". 

I used a custom table example but it should be available as a general custom field option. But, it seems especially compelling to be able to perform operations between different fields in a custom table. 

  • ADMIN RESPONSE
    Feb 6, 2019

    It is now possible to create calculated fields with worksheets.

    Think of worksheets in Aha! as two-column spreadsheets. You can create as many rows as you need and they automatically calculate data. You can use worksheets to do basic math — add, subtract, multiply, and divide. But you can also perform more complex functions, such as averaging or calculating the time between two dates.

    With this initial release, worksheet fields can reference any other worksheet field. We are actively working on an enhancement that would allow worksheets to reference any other field in Aha! We will keep this idea updated as we make progress there.

  • Attach files
  • Admin
    Austin Merritt
    Reply
    |
    Feb 7, 2019

    Hi there. This is available as of yesterday. Sorry for the confusion with the release time frame. I have removed that to make the status more clear. Thanks!

  • David Desrosiers
    Reply
    |
    Feb 6, 2019

    Sorry I'm a bit confused, is this released or in progress?
    I see contradictory messages
    Status is "Shipped" and announcement "It is now possible"

    but it is also labeled with "Release time frame 1 month"

    Thanks

  • William Orme
    Reply
    |
    Dec 20, 2018

    My use case is for calculated scorecard off custom fields and Feature fields such as Estimate, so we can run algorithms based on data collected in Salesforce, Zendesk and Jira to give auto-updating scores.

  • Guest
    Reply
    |
    Nov 16, 2018

    I have a task to work with 3 point estimations using Aha! To secure I have my data in AHA as long as possible instead of exporting to excel.

     

    I have added this calculation E = (a + 4m + b) / 6 in a scorecard for each team making the 3 point estimate.

     

    When this estimates are typed into the scorecards I have made a pivot table to be able to sum the estimates for each feature and for each team.

     

    But how do I get the calculation of the standard diviation visualized using this calculation. SD = (b − a) / 6

     I would like to have a tool similar to what is available in the scorecard to make my individual calculations.

      

    From Wikipidia

    https://en.wikipedia.org/wiki/Three-point_estimation

     

    From Wikipedia, the free encyclopedia

    The three-point estimation technique is used in management and information systems applications for the construction of an approximate probability distribution representing the outcome of future events, based on very limited information. While the distribution used for the approximation might be a normal distribution, this is not always so and, for example a triangular distribution might be used, depending on the application.

    In three-point estimation, three figures are produced initially for every distribution that is required, based on prior experience or best-guesses:

    • a = the best-case estimate
    • m = the most likely estimate
    • b = the worst-case estimate

    These are then combined to yield either a full probability distribution, for later combination with distributions obtained similarly for other variables, or summary descriptors of the distribution, such as the meanstandard deviation or percentage points of the distribution. The accuracy attributed to the results derived can be no better than the accuracy inherent in the 3 initial points, and there are clear dangers in using an assumed form for an underlying distribution that itself has little basis.

     

    Estimation

    Based on the assumption that a double-triangular distribution[clarification needed] governs the data, several estimates are possible. These values are used to calculate an E value for the estimate and a standard deviation (SD) as L-estimators, where:

    E = (a + 4m + b) / 6

    SD = (b − a) / 6

    E is a weighted average which takes into account both the most optimistic and most pessimistic estimates provided. SD measures the variability or uncertainty in the estimate. In Project Evaluation and Review Techniques (PERT) the three values are used to fit a PERT distribution for Monte Carlo simulations.

    The triangular distribution is also commonly used. It differs from the double-triangular by its simple triangular shape and by the property that the mode does not have to coincide with the median. The mean (expected value) is then:

    E = (a + m + b) / 3.

    In some applications,[1] the triangular distribution is used directly as an estimated probability distribution, rather than for the derivation of estimated statistics.

  • Justin Reed
    Reply
    |
    Oct 4, 2018

    Happy to pile on here. Ultimately, I have to export to Excel to get some of the functionality I need. I already fight with my teams to get out of Excel and into Aha, so it's unfortunate I have to tell them to use Excel to get calculations (most frequently used: date diff, basic arithmetic, average, min, max, count, if/else). We need calculations for a number of reasons, but like other commenters, we use them most when estimating and budgeting.

  • Guest
    Reply
    |
    Sep 11, 2018

    Ability to for conditional formulas in custom fields would be great also,  Like If "Release Date" <= Today, Custom Field = "OverDue"

  • Guest
    Reply
    |
    Sep 11, 2018

    I need this as well and need to be able to create IF statements.   I need to report on whether Ideas are created Internally or Externally.  I would like to create a calculated field that would look at the Submitted by Domain and determine Internal if the domain is our company domain or blank (Ideas created inside of Aha leave that blank) and External if it’s anything else.

  • Dan Eisenhut
    Reply
    |
    Aug 22, 2018

    Definitely needed!  Please make sure that it handles using a custom text string as a variable when the string includes symbols, such as a percent sign (e.g. "57%").

  • Julie Edwards
    Reply
    |
    Jun 29, 2018

    This would be SO handy!  Please implement this soon!

  • Guest
    Reply
    |
    Apr 16, 2018

    It would be helpful to also be able to access metrics from within scorecards as part of the custom field formula builder. One would then be able to calculate certain values such as "Complexity" which may be made up of a set of metrics within a scorecard vs. Effort which may be made up of another set of metrics within the same scorecard.

  • Guest
    Reply
    |
    Jan 10, 2018

    I totally need this ability.  Support suggest using Pivot tables.  That provides basic functionality, the calculations meant here are needed.  Also, I do not want custom table to make this functionality to work.  This should used on a list view/report.

  • Guest
    Reply
    |
    Dec 12, 2017

    I'm buying my team calculators for Christmas so they can do addition, subtraction, and division of a few of their fields in Aha each week.

  • Guest
    Reply
    |
    Nov 30, 2017

    Not having the ability to calculate (particularly subtract, add, and divide) is killing me. I have a lot of fields that need to be divided by other fields or a static number. Without the ability to do calculations in Aha! I'm forced to add these calculations into my source data when importing from our legacy system. Not ideal.

  • Jennifer Booker
    Reply
    |
    Nov 8, 2017

    It would be nice to have the ability to have logic functions IF and SUMIFS

  • Guest
    Reply
    |
    Oct 24, 2017

    Roll up of Product Level information to the Product Line/Portfolio/Company Level. Suppose I am entering the size for a particular Product / Feature then it should roll up to the Product Line or Portfolio or Company level.

  • Daniel Scudds
    Reply
    |
    Aug 15, 2017

    Definitely second this requirement. This functionality is required to generate charts based on the data from lists. 

  • Devik Lansing
    Reply
    |
    Aug 9, 2017

    AGree that we would need operations on custom fields and tables.  We really really need calculated fields in general.

  • Guest
    Reply
    |
    Aug 8, 2017

    In addition to the other excellent comments here, I'd add that a formula field which can reference any other custom field or system field should be available everywhere.  

    As an example, I'd like to have a bubble chart whose bubble's color are determined by a score.  But the bubble color can only take a text value as input.  So, I'd like to work around that limitation by using a formula field for my scorecard's final score, in which the numeric total is used as an offset into a list of text values.  Or simpler, leave the scorecard alone but use it's numeric score in a formula field which does this lookup, and then assign that field as the input to the bubble chart.

  • Guest
    Reply
    |
    May 4, 2017

    I'd like to suggest to have the planned - and actual spend per release/sprint and that those can be summed up to the "total planned spend" or "total actual spend".

  • Guest
    Reply
    |
    Apr 13, 2017

    My use case is to have a calculated field for the feature score. For example, we're planning to use multiple "scorecards" for each feature  - a set of questions around consumer need, a different one for financials, another for strategic fit, etc. Each of these should roll up to a single calculated score.

  • Load older comments
  • +27
22 MERGED

Perform Calculations using two fields

Merged
In list view or pivot view, I want the ability to do math operations using multiple fields in the dataset. For example, if I have a revenue and a cost column of data I want to be able to calculate ROI. And,no I do not want to use a score card to s...
Guest over 6 years ago in Reports 0 Shipped
1 MERGED

Designed Requirements forms for Specifically Software Engineers Role

Merged
Hi Aha! team, By using the requirements form I noticed it will be nice to have a very specifically designed form for software engineers, so for example: If the form includes an html select element to choose and input field and one html sel...
Guest about 5 years ago in Features 0 Shipped
27 MERGED

Ability to calculate the child budget fields to the overall parent budget

Merged
IDEA: Estimate Roll Up at the Goal level – Ability to calculate the child budget fields to the overall parent budget. Can Aha perform a total roll up from the lowest level up to the Goal level. Ex: Feature budget fields, roll up to the Master Feat...
Guest almost 7 years ago in Product 1 Shipped
3 MERGED

Allow users to specify formulas for custom numeric fields.

Merged
We estimate our features (and sometimes requirements) at a functional level. This is then summed up to the overall time estimate, but we track the allocations for each group. Therefore, we need to be able to specify a feature estimate as: Feature:...
Guest over 9 years ago in  0 Shipped
22 MERGED

Creation of Custom Field type, in which can be added calculations and formulas.

Merged
I want in custom table to add field, in which I can add diferent formulas (like in excel). For example, if I have approved amount and actual amount, in third cell to calculate the difference between the two cells, or to put even more complicated f...
Guest over 6 years ago in Ideas 0 Shipped
19 MERGED

create a custom field that is a formulae

Merged
as an example, I want to create a new field that will divide the AHA score by a custom field [effort] to give me a combined total. I can do this in the scorecard, but id like to keep the fields separate as different people will be updating
Mark Brown about 6 years ago in Application 0 Shipped
8 MERGED

Ability to reuse API Keys as part of an equation to derive a new value - Planning Poker

Merged
The ability to create a "result" field that derives its value (as part of an equation) from other fields within the same layout? For example, Planning Poker Two input fields for Effort and Value with the following API Keys Third field called ...
Guest over 5 years ago in Features 0 Shipped