This is an amazing update! I have been playing around with it and it opens so many new opportunities.
Just wanted to point out that as I was testing the advance editor I discovered that if one of the fields in a sum is empty, it will not perform the calculation. You have to replace the empty field with a 0 for it to perform the calculation.
This is something that you should definitely try to fix. The editor should assume that if a field is empty, it means 0.
Hi @Tetsuo_Kawakami , nice hack! Also, I found that if you add a +0 on the end, you will get the result in minutes! And if you divide that by 60 then you will get the value in ‘numeric’ hours, i.e 10h30m will display as 10.5, as per below formula which you can copy paste into your advanced editor: ( [[$ACTUAL_TIME]] + 0 ) / 60
Refer to my post here for the complete workaround on getting dashboards to display in hours/days instead of weeks/days.
Hi - would it possible to multiply a number by a % using this feature please? We have tasks that carry a total deal value and have a separate field that indicates the % complete of the task. So it’d be good to be able to multiply one by the other to arrive at a current value of the job. Thanks!
On a similar note, can this be used in a form to tally response results.
For example, where the respondent has 4 options to choose from, each worth a distinct numerical value, and then once the form is submitted we get a tally of their score?
Hi @Scott_Burkinshaw , sure you can! For the formulas, simply replace your percentages with a decimal, so for example, 55% would be 0.55, or +55% would be 1.55
For example, if you want to get say 15% of one of your number field’s value (eg. your ‘Cost’ field), you would input in the formula advanced editor as such: [Cost field]*0.15 to give you the value of that 15%.
If you want the total value, i.e. your cost field + 15%, then you would input in the formula advanced editor as such: [Cost field]*1.15
You can also have a look at my post below, especially numbers 9-12 where I show examples applying tax or discounts:
Hi @Samantha_Di_Lullo , currently the feature does not support mapping dropdown custom fields (such as single-select or multi-select) to a number value. You could only achieve this if your form’s questions contained ‘number’ or ‘date’ type questions which could be mapped to relevant fields in your project, from which a formula field would be able to provide a tally score.