Evaluate the automation to unsubscribe. part 2
2021-01-11 10:59:34
We evaluated this box https://crm-onebox.com/en/support/other/2171-otsiniti-avtomatizatsiyu-dlya-dovid...
It is necessary to supplement additionally:
Rozrahunok forecast value
if not all the values for the month are saved in the end, then it is necessary to systematically unravel the number of working days until the end of the month, and to accept the value of the field (you can specify) as a constant for all days (which are lost until the end of the middle value), and the difference
For example
Maybe so potentially not filling in the value of the adder https://prnt.sc/vmwsuw - only one field.
Remaining value 318.00
Number of days to the end of the month https://prnt.sc/vmwtxc
If you open it in the tables, then go to https://prnt.sc/vmwuun
Gave the calculated average value for all values \u003d The sum of the field for each day of the current month https://prnt.sc/vmwvbh divided by the number of entries for the day (for the current month, potentially not completed https://prnt.sc/vmx
Original question is available on version: ru
It is necessary to supplement additionally:
Rozrahunok forecast value
if not all the values for the month are saved in the end, then it is necessary to systematically unravel the number of working days until the end of the month, and to accept the value of the field (you can specify) as a constant for all days (which are lost until the end of the middle value), and the difference
For example
Maybe so potentially not filling in the value of the adder https://prnt.sc/vmwsuw - only one field.
Remaining value 318.00
Number of days to the end of the month https://prnt.sc/vmwtxc
If you open it in the tables, then go to https://prnt.sc/vmwuun
Gave the calculated average value for all values \u003d The sum of the field for each day of the current month https://prnt.sc/vmwvbh divided by the number of entries for the day (for the current month, potentially not completed https://prnt.sc/vmx
Answers:
Hello. You describe the logic for the current month. And if, for example, you fill out a reference book for the previous year or for the next, what should happen?
12.01.2021, 18:13
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
Hello. You describe the logic for the current month. And if, for example, you fill out a reference book for the previous year or for the next, what should happen?
The accounting period is always 1 month, the average should be taken per month. Can I rely on the date in the reference field? That is, we will have a reference field with the "Date" type, we indicate the date for which we will take the value
13.01.2021, 11:38
Original comment available on version: ru
What about the rating, can you give an answer?
26.01.2021, 16:20
Original comment available on version: ru
The accounting period is always 1 month, the average should be taken per month. Can I rely on the date in the reference field? That is, we will have a reference field with the "Date" type, we indicate the date for which we will take the value. From this date, we take the month and year, so we understand which values to take for the calculation.
27.01.2021, 22:47
Original comment available on version: ru
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
Copyright © OneBox 2024
