Access to KPI value to use in other models

[ska-ibees]

@sbidoul As advised, same question in a new issue.

Question:
Is it possible to use value of a KPI (computed value from mis report) in another model?

Use case:
Actually I am trying to create a mis report to calculate total fixed expenses of last month and to use this value in pricelist to calculate final price of a product.

Creating MIS report is straight forward. Thanks for the demo module and provided documentation.
However, not getting any clue to get and use KPI's value into another model.

Would apprecaite any help in this regard.

Thanks.

[sbidoul]

@go4site The evaluate method of mis.report should help.

Don't forget to do performance tests. While it is fast enough for interactive display of a report, it might not be enough for including in price list calculations. This depends on many factors.

[ska-ibees]

Thanks a lot for the help.

[lili94]

hi @go4site do you have any idea how to create tow colomun with different expression please

[ska-ibees]

Hi, Please share some more info as what you need to accomplish?

[lili94]

Thanks @go4site ,in my active balance sheet I have 2,coloumn with different expressions each one have his account for example
Coloum1_2019brut_capital Emis pbal70
Column 2 net pbal890 in the same line