https://b2bhub.crm-onebox.com/admin/report/desiner/6/view/?filter_order_moveloggruopby=&filter_order_moveloggruopbyvalue=&filter_order_productionstoragenameid%5B%5D=20&filter_order_productionstoragenameid%5B%5D=8&filter_storagemove_datefrom=2021-02-06mo&filter_storagenameid%5B%5D=8&filter_storagemove_datefrom=2021-02-06mo&filter_storagenameid%5B%5D=20 -06&filter_product_categoryid%5B%5D=1011&filter_product_productid=&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0% D1%82%D1%8C
Here is a link, in this report it does not correctly count the number of processes. noticed after unloading it in XLS
https://b2bhub.crm-onebox.com/admin/report/desiner/6/view/?filter_order_movelogg... -06&filter_product_categoryid%5B%5D=1011&filter_product_productid=&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0% D1%82%D1%8C Here is a link, in this report it does not correctly count the number of processes. noticed after unloading it in XLS
Poltoratsky Dmitry Client wrote: https://b2bhub.crm-onebox.com/admin/report/desiner/6/view/?filter_order_movelogg... -06&filter_product_categoryid%5B%5D=1011&filter_product_productid=&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0% D1%82%D1%8C Here is a link, in this report it does not correctly count the number of processes. noticed after unloading it in XLS. there are 49 processes in the report, and when calculating in excel, the sum of the processes is 72 pieces
[quote]
Poltoratsky Dmitry
Client wrote:
https://b2bhub.crm-onebox.com/admin/report/desiner/6/view/?filter_order_moveloggruopby=&filter_order_moveloggruopbyvalue=&filter_order_productionstoragenameid%5B%5D=20&filter_order_productionstoragenameid%5B%5D=8&filter_storagemove_datefrom=2021-02-06mo&filter_storagenameid%5B%5D=8&filter_storagemove_datefrom=2021-02-06mo&filter_storagenameid%5B%5D=20 -06&filter_product_categoryid%5B%5D=1011&filter_product_productid=&templateid=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0% D1%82%D1%8C
Here is a link, in this report it does not correctly count the number of processes. noticed after unloading it in XLS. there are 49 processes in the report, and when calculating in excel, the sum of the processes is 72 pieces
The indicators are correct. If you have several products related to the same process, then it takes into account 1 time in the final quantity. That is, in fact, this is not the sum of the column, but the number of unique processes where there are filtered products.
The indicators are correct.
If you have several products related to the same process, then it takes into account 1 time in the final quantity. That is, in fact, this is not the sum of the column, but the number of unique processes where there are filtered products.
maybe so, but if you take a calculator and count the number of processes in this column, it will be 72 and not 49 as it is written in the report
maybe so, but if you take a calculator and count the number of processes in this column, it will be 72 and not 49 as it is written in the report
[file]4062[/file]
Poltoratsky Dmitry Client wrote: OK, understood. Thanks for answers. Can you describe why it's done this way? Display number of unique processes? Maybe I can put it on somehow.
[quote]
Poltoratsky Dmitry
Client wrote:
OK, understood. Thanks for answers. Can you describe why it's done this way? Display number of unique processes? Maybe I can put it on somehow.
[/quote]
Can you describe why it's done this way? Display number of unique processes?
Because such was the condition when developing the report. And this is logical - to see the data without duplication (after all, if you count the amounts / quantities for orders several times, this is not true).
[quote]
Can you describe why it's done this way? Display number of unique processes?
[/quote]
Because such was the condition when developing the report.
And this is logical - to see the data without duplication (after all, if you count the amounts / quantities for orders several times, this is not true).
Thank you. Could you consider one more of my appeals, we have problems with access rights for employees. They do not display all6 statuses ... in general, I described everything in it ... our processes have stalled
https://crm-onebox.com/ru/support/contacts/7594-problemka-ne-otobrazhayutsya-v-pravah-dostupa-vse-statusi-biznes-protsessa/
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up