Refinement in the Marketing report

What variable is missing specifically? The balance as [became] only in the warehouses specified by the multilist?

[quote] Tyndyk Maxim Vadimovich wrote: What variable is missing specifically? The balance as [became] only in the warehouses specified by the multilist? [/quote] There are no formulas for variables at all like in Balance. For a reason, to make the report run faster. If you add it and it does not affect the speed, then you need a solution similar to the Balance in warehouses with the ability to set variables: Current balance, reserve, Quantity of goods at a certain process status. In particular, the following statuses are needed: Pre-order no product without reserve - Postponed no product without reserve

It is impossible to modify something so that it does not affect the speed - more conditions - more mathematical operations - more time. Give a link to the report where to finalize and indicate for which column the condition to change / add a new column?

[quote] Tyndyk Maxim Vadimovich OneBox production Premium partner wrote: It is impossible to modify something so that it does not affect the speed - more conditions - more mathematical operations - more time. Give a link to the report where to finalize and indicate for which column the condition to change / add a new column? [/quote] [quote] Timofeev Artem Olegovich KTS Premium partner wrote: The client wants to do by analogy for the report - https://rozpakui.crm-onebox.com/admin/report/desiner/49/view/ Where it is necessary for the column Calculation of the Free balance for goods in the status "Withdrawal from the range" and "Inactive" to execute according to the formula: Remaining in liquid warehouses - In reserve - Pre-order no goods excluding reserve - Postponed no goods excluding reserve [/quote] Here I wrote in the description of the task. Is there anything else needed?

[quote] Where it is necessary for the column Calculation of the Free balance for goods in the status "Withdrawal from the range" and "Inactive" to execute according to the formula: Remaining in liquid warehouses - In reserve - Pre-order no goods excluding reserve - Postponed no goods excluding reserve [/quote] That is, in fact, you need to duplicate the column "Available balance for today", but in order to: 1. it was considered only for certain warehouses 2. only for products whose additional field is equal to one of the specified values Or is it necessary for the column "Available balance for today" to apply such logic if the field of the product is equal to the value - but in the description we are talking about some non-existent column "Calculation of Free balance ..."

[quote] Tyndyk Maxim Vadimovich OneBox production Premium partner wrote: [quote] Where it is necessary for the column Calculation of the Free balance for goods in the status "Withdrawal from the range" and "Inactive" to execute according to the formula: Remaining in liquid warehouses - In reserve - Pre-order no goods excluding reserve - Postponed no goods excluding reserve [/quote] That is, in fact, you need to duplicate the column "Available balance for today", but in order to: 1. it was considered only for certain warehouses 2. only for products whose additional field is equal to one of the specified values Or is it necessary for the column "Available balance for today" to apply such logic if the field of the product is equal to the value - but in the description we are talking about some non-existent column "Calculation of Free balance ..." [/quote] Clarified: For these 2 reports: https://rozpakui.crm-onebox.com/admin/report/desiner/49/view/?filter_analysis_datefrom=2021-06-29&filter_analysis_dateto=2021-06-29&filter_analysis_stock=0&filterfrom_analysis_showperiod=&filterto_analysis_showperiod=&filter_product_productid=&product_filtercustomnameotvetstvenniymenedzher19=&product_filtercustomotvetstvenniymenedzher19=&templateid=&ok =%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C Column - [file]7720[/file] and this report: https://rozpakui.crm-onebox.com/admin/report/desiner/40/view/?filter_order_stockforecastdatefrom=2021-06-29&filter_order_stockforecastdateto=2021-06-29&filter_product_productid=&product_filtercustomnameosnovnoypostavshchik15=&product_filtercustomosnovnoypostavshchik15=&product_filtercustomnameotvetstvenniymenedzher19=&product_filtercustomotvetstvenniymenedzher19=&templateid=&ok=% D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C Column - [file]7721[/file]

[quote] Tyndyk Maxim Vadimovich OneBox production Premium partner wrote: [quote] Where it is necessary for the column Calculation of the Free balance for goods in the status "Withdrawal from the range" and "Inactive" to execute according to the formula: Remaining in liquid warehouses - In reserve - Pre-order no goods excluding reserve - Postponed no goods excluding reserve [/quote] That is, in fact, you need to duplicate the column "Available balance for today", but in order to: 1. it was considered only for certain warehouses 2. only for products whose additional field is equal to one of the specified values Or is it necessary for the column "Available balance for today" to apply such logic if the field of the product is equal to the value - but in the description we are talking about some non-existent column "Calculation of Free balance ..." [/quote] Clarified: For these 2 reports: https://rozpakui.crm-onebox.com/admin/report/desiner/49/view/?filter_analysis_datefrom=2021-06-29&filter_analysis_dateto=2021-06-29&filter_analysis_stock=0&filterfrom_analysis_showperiod=&filterto_analysis_showperiod=&filter_product_productid=&product_filtercustomnameotvetstvenniymenedzher19=&product_filtercustomotvetstvenniymenedzher19=&templateid=&ok =%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C Column - [file]7722[/file] and this report: https://rozpakui.crm-onebox.com/admin/report/desiner/40/view/?filter_order_stockforecastdatefrom=2021-06-29&filter_order_stockforecastdateto=2021-06-29&filter_product_productid=&product_filtercustomnameosnovnoypostavshchik15=&product_filtercustomosnovnoypostavshchik15=&product_filtercustomnameotvetstvenniymenedzher19=&product_filtercustomotvetstvenniymenedzher19=&templateid=&ok=% D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C Column - [file]7723[/file]

Your comment did not give me confirmation/denial of the logic I indicated.

[quote] Timofeev Artem Olegovich KTS Premium partner wrote: Or is it necessary for the column "Available balance for today" to apply such logic if the field of the product is equal to the value - but in the description we are talking about some non-existent column "Calculation of Free balance... [/quote] Above specified 2 columns specifically. In the description, I indicated what logic I want to apply. What are the questions?