How to calculate Duration between two duration fields from 2 different tables?

[Divya Sri K]

I have a requirement to calculate the duration between two fields from two different tables and i have to  show the calculated result in a report. I tried using the database view and i got the required fields from both the tables, but the configure functional field button is disable(Expected Behavior) in reports to calculate the using Datediff function. So I thought of creating a new function filed in db view table, but that also didn't worked as the calculated result field is not displaying on the reports.

So is there any option to calculate the Datediff between fields from 2 different tables and show that result on reports, rather than creating a new field on native table?

[Divya Sri K]

@Ankur Bawiskar 

Could you please assist here?

Thank you!

[Divya Sri K · Accepted solution]

Hello, I can able to get the calculation done for duration difference between two duration fields from two related tables by creating function field in the dictionary entry. I used glidefunction:datediff(closed_at, sys_created_on) in the function definition. 

Given the database view table for creating new function field and created report on the same db view table to show that calculated result.

If we donot found the function field in the form entry we can configure the list to get it.