Home › Forums › Discussion Forum › Custom fields
Dear Gents,
Could you please help to choose right FUNCTION code in Formula section while editing custom field.
I am trying to make some calculation however due the words (DAYS) in duration COLUMN the formula doesn’t work. That is why I would like to duplicate digits, numbers from duration column to another one in order to use formula.
Thanks a lot in advance
Your help and support are appreciated.
Kindly
Ramil
Ramil, good question. Actually, the duration column in a formula works. It is only the display that shows the Days label. Duration is stored in minutes, so if you use it in a formula you may need to divide by 480 (if using the standard calendar) to get the number of days. Hope that helps…
Thank you so much Dear Larry.
Have a nice day.
PS: I will be appreciated if you can help me with visual reports. I am trying to generate report by showing my custom fields.
I wouldn’t call me an expert on the Visual Reports reporting function but you should be able to edit the template and add custom fields to the report from there…??