1b.app
Link copied -

Evaluate the automation to unsubscribe. part 2

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
Оригинальный вопрос доступен на версии: ru One Bogs - One Genius

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
Оригинальный комментарий доступен на версии: ru

Суханицкий Андрей OneBox CORP
OneBox Corp - Интегратор
Personal license

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
One Bogs - One Genius Оригинальный комментарий доступен на версии: ru

Суханицкий Андрей OneBox CORP
OneBox Corp - Интегратор
Personal license
What about the rating, can you give an answer?
26.01.2021, 16:20
One Bogs - One Genius Оригинальный комментарий доступен на версии: ru

Суханицкий Андрей OneBox CORP
OneBox Corp - Интегратор
Personal license
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
One Bogs - One Genius Оригинальный комментарий доступен на версии: ru

around 6h
01.02.2021, 15:01
Оригинальный комментарий доступен на версии: 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