I want to calculate the trend formula.
MTD ACT of Latest Date / Calendar Datecount up to this Latest Date * Date of the Month
We have Act data till 19th August and MTD Actual is nothing but cumulative of ACT
MTD ACT of Latest Date=19-08-2021
Calendar Date count up to this Latest Date=19
Date of the Month=1 to 31 days() so multiplied by 1 ,2 and so on till 31)
So I have to calculate (554089323/19)*1 ,(554089323/19)*2
My main concern is today is 24th then how would I Get 19 number.
Please suggest me how to build up formula.
@Sunny_talwar, @Swuehl,@ kaushik.solanki ,@sunny t,Kushal_Chawda
While calculating the MonthEndDate variable use the Max of the ACT which is 19th so it will take values from start of the month until the max date which is available in ACT field