Solved! Go to Solution.
Views
Replies
Total Likes
Hello Thomas,
the field you are trying to reference to in your formula is a custom field.
Custom fields are referenced using the DE: prefix.
To get system fields into calculated fields, I would have suggested to have a look into the API Explorer under Project.
There you will find two fields, which could help:
Unfortunately the calculated fields editor is crap. You will get an error message trying to use
{actualWorkRequiredDouble}
although it shows the correct double value if you select a corresponding project under Preview on an existing object before.
So, to be able to save your form, you will need to work with the field actualWorkRequired. This will provide your hours in minutes, so to get a decimal, you will need to calculate like this
{actualWorkRequired}/60
I hope this helps.
Regards
Lars
Views
Replies
Total Likes
Hello Thomas,
the field you are trying to reference to in your formula is a custom field.
Custom fields are referenced using the DE: prefix.
To get system fields into calculated fields, I would have suggested to have a look into the API Explorer under Project.
There you will find two fields, which could help:
Unfortunately the calculated fields editor is crap. You will get an error message trying to use
{actualWorkRequiredDouble}
although it shows the correct double value if you select a corresponding project under Preview on an existing object before.
So, to be able to save your form, you will need to work with the field actualWorkRequired. This will provide your hours in minutes, so to get a decimal, you will need to calculate like this
{actualWorkRequired}/60
I hope this helps.
Regards
Lars
Views
Replies
Total Likes
Hi Lars,
Thanks very much for the explanation.
I have tried your suggestion:
{actualWorkRequired}/60
I have also tried a number of other System fields from the list, but in each case the field is showing as blank in the project business case form.
I'm starting to think that I need more detail in the calculation field. I've attached some settings and results for reference, using:
{actualWorkRequired}
Thanks
-Tom
Views
Replies
Total Likes
Hi Lars,
Please ignore, it's working now. For some reason the formula doesn't update unless you log out and then log back in.
Thanks again.
-Tom
Views
Replies
Total Likes