How to add time_spent_sum from Tkt to CABI universe?

[Albino]

I'm trying to add the time_spent_sum field from Tkt object to CABI universe to use this in a new report, but the Universe Designer shows the following messages for each case:

 

Case 1: tkt.time_spent_sum
Error: The expression type is not compatible with the object type.

 

 

Case 2: PdmSeconds(tkt.time_spent_sum)
Error: Parse failed: Exception: DBD,[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]AHD12028:PdmSeconds argumento NULL tem um tipo inválido string at time_spent_sum )State:12028

 

 

 

Can anyone guide me if I'm doing something wrong or if this really possible?

[Legacy User]

Hi,

 

Try to use a String type, for formulas Try to use on Report Formulas.

 

Best Regards.