Predictive Closing for Fiscal Quarter

[marishnagendran]

Dear All,

In Bar chart it shows actual Sales for fiscal Quarter. I need Predictive closing  as another expression

For Example.

1-Apr-2019 to 04-Jun-2019 my Sales is 10 Lakhs.  What is my projected closing at 30-Jun-2019

First Quarter period is APR,MAY,JUNE

[bramkn]

There is no function to do this. You will need to calculate your prediction. There is too many factors for us to just give you a calculation.

[marishnagendran]

Thanks for replay

My Factor is Today 4-06-2019 My Sales from 1-apr-2019 to till date 10 Lakhs

I want to calculate current date is comes from which Quarter and how many days passed. In this Example 

65 days passed,Then 1000000/65 = 15384.61 is my 1 Day Sales

From Date and End Date to be calculate for Current Quarter (i.e 1-Apr-2019 to 30-Jun-2019) 91 Days

15384.61* 91 = 14,00000 Lakhs

[bramkn]

Do you have a master calendar with the Quarter? if not Add one. You can also add daynr of Quarter in this master calender to make things easier.
And then you can use set analysis to do some calculations.

[jonathandienst]

The detailed solution is totally dependent on the data model in your app - especially how you have implemented the calendar.

I suggest that you create a small sample with the the same data structure and some sample data. It does not need to be real data but it should be representative of the real app. Also include the table or chart that will display the quarter's amount to date. Finally, specify the expected output with the data you supplied - although your explanation in the initial post may be sufficient.