Calculated field not working in report

[Ahmmed Ali]

Hello All,

I have created one calculated field on server table (cmdb_ci_server), in which i have script as "return current.cpu_count*curent.cpu_core_count". the field type is integer. this is working fine in form view and list view of server table. even it is working fine if we take report on server table.

but if i take report on configuration item and add above field to the report, it is not showing the values.

to debug, i have created same field with same calculated script in windows server table (cmdb_ci_win_server) and i added this field in cmdb_ci table report, it is working.

for server table field the value is not showing in list view.

Note: both cpu count and cpu core count fields are on computer table.

below is screenshots for reference.

here windows server table field is showing data but server table field is not showing the data.

at the same time, if i take report on server table, i am getting data in both the fields (i.e windows server table field and server table field).

Please help me to resolve the issue.

Thanks,

Ali

[saidinesh]

Calculation fields just calculates on the view and they never stores in the server unless the record is saved.

[Community Alums]

I had the same issue recently. I have created a function field on the report to replace the calculated field. It worked for me.