Apply conversion type while configuring a function field in a report

[Valentina1]

Hi,

I would need to convert a Duration field into Hours (float) and use it in a report. I would like to take advantage of the "Configure function field" functionality offered by the Reporting and avoid creating a new field in the source table 

Can the type conversion be made inside the Configure function field functionality of the Report or Do I have to create a separate function field in the source table and then use it in the report?

Thank you,

Valentina

[Sohail Khilji · Accepted solution]

Hi @Valentina1 ,

I just looked into it on my instance.

Its not possible via standard reporting  'configure function field'. Reason - the duration field being String as highlited below. (The string can be of diffrent varients like 10 mints [OR] 1 day 1hours [OR] 1 day 1 hour 1mint etc..) so its not possible to create a function field for dynamic strings using substring operations... refer the below image.

I hope i answered your query

[Valentina1]

Thank you, Sohail.