Dictionary Entry - Function Definition not working

[Navaneeth1]

I have a dictionary entry of type duration for a custom scoped application table. This dictionary entry intends to find the difference between two DateandTime fields. 

I created the same and in the Function definition I entered the code given below:
glidefunction:datediff(resolved_at, opened at)

However, the field shows 0 days 0 hours etc. Is there anything wrong with the code? Does this not work on old/pre-existing records?

The screenshot of the Dictionary Entry is given below: (same image is attached as well)

[Navaneeth1]

@tharun_kumar_m 
I don't have any other Report_view ACLs for this table. This table is inheriting from the incident table though but no other field shows this error on the report.

[tharun_kumar_m]

@Navaneeth1 ,

Maybe because you are inheriting from the incident table, you might be able to see the inherited columns in report. But for this newly created custom field, please try to create an ACL  custom_table.* and provide the necessary roles.

If my answer has helped with your question, please give a thumbs up.

Best regards,

Tharun Kumar