When using queries end up with TypeError

[robyf70]

I'm trying to get queries on sale order to be used as KPI, below an example how I have configured it

but I'm ending up always with the traceback below. Maybe I'm missing something, any idea how to fix it?

File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_instance.py", line 681, in compute
kpi_matrix = self._compute_matrix()
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_instance.py", line 673, in _compute_matrix
self._add_column(aep, kpi_matrix, period, period.name, description)
File "/OtherData/oca/mis-builder/mis_builder_budget/models/mis_report_instance.py", line 64, in _add_column
aep, kpi_matrix, period, label, description)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_instance.py", line 641, in _add_column
aep, kpi_matrix, period, label, description)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_instance.py", line 601, in _add_column_actuals
period._get_additional_query_filter)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report.py", line 817, in declare_and_compute_period
locals_dict, eval_expressions, eval_expressions_by_account)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report.py", line 691, in _declare_and_compute_col
kpi, col_key, vals, drilldown_args)
File "/OtherData/oca/mis-builder/mis_builder/models/kpimatrix.py", line 217, in set_values
drilldown_args, tooltips)
File "/OtherData/oca/mis-builder/mis_builder/models/kpimatrix.py", line 245, in set_values_detail_account
self.lang, row.style_props, kpi.type, val)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_style.py", line 167, in render
style_props.prefix, style_props.suffix)
File "/OtherData/oca/mis-builder/mis_builder/models/mis_report_style.py", line 179, in render_num
value = round(value / float(divider or 1), dp or 0) or 0
TypeError: unsupported operand type(s) for /: 'AutoStruct' and 'float'

[sbidoul]

@robyf70 can you show me your KPI expressions?

Try using sale_order_sale.amount_untaxed.

[robyf70]

Ok! That works pretty fine! I was trying just now the syntax sale_order_sale[amount_untaxed]. Would be nice to mention in the help how to use fields in query for the expressions.

[sbidoul]

Would be nice to mention in the help how to use fields in query for the expressions.

Yep, that should be done quite soon now.

Note when you use aggregation functions in queries you also have access to a sale_order_sale.count field. If the aggregation function is absent, sale_order_count is a list of objects with the fetched fields as attributes.