calculation Filed on List of records by MySql query

[shandybt]

Dear Sergey or anyone,

I've use List of records by MySql query to recap my sub entity table into parent entity but it cannot calculation value from subentity filed
its any solution to calculation the field?

thank you

[support]

This field type not supported to calculate totals. You can to use numeric field type (Formula or MySQL formula)

[shandybt]

I Have another way with add another field with MySql Formula and its works

I attach the modification sample

Thank you sergey