Forward Stock Cover Calculation

[george456]

Dear Community

I have a situation that requires some help. I have to calculate Forward stock cover. The basic calc will be like this:

Sum ( Units) month + Average of three months Units into future

i.e Closing Stock of Month ( Dec2019) / Average of Units (Forecasted Jan 2020, Feb 2020 , March 2020)

I am looking forward to your reply

Regards

[Anil_Babu_Samineni]

Perhaps this?

if(Month<=MonthName(Today()),sum({<Month={"=MonthName(Today())"} Units)
,linest_m(total aggr(if(sum(Units),sum(Units)),Month),Month)*Month
+linest_b(total aggr(if(sum(Units),sum(Units)),Month),Month))

[george456]

Hi

Thanks for the reply. I however am not to familiar with this syntax. Let me try and will revert soonest

Regards