
Creator
2019-11-28
06:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Forward Stock Cover Calculation
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
560 Views
2 Replies
2019-11-28
07:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
545 Views

Creator
2019-11-28
07:57 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Thanks for the reply. I however am not to familiar with this syntax. Let me try and will revert soonest
Regards
534 Views
