Implement Calc in FODS template

I have the following setup in my FODS:

I want the formula to be = Qty x Unit List Price

So I tried like this:

And after generating the Excel file.. the formula is not repeated following the row

So I searched in the forum and found value-issues-on-spreadsheet-reports

But I still cannot figure it out.

Any concrete code snippet would be helpful.

Thank you in advance.

Bromo

The formula are not updated by the relatorio loops.
But I think it would be a great feature to add to relatorio: updating formula the same way the UI does when expanding it horizontally or vertically. It could follow a little the same design as the column looping.

Meanwhile I would advise to make the computation in relatorio with a Python expression.

1 Like

Okay @ced I will use python.
Please do not forget to implement model that can render View of DB too :slight_smile: