Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator

## calculate trend on latest date

Hi Team,

I want to calculate the trend formula.

MTD ACT of Latest Date / Calendar Datecount up to this Latest Date * Date of the Month

"Latest Date" does NOT mean "Todays date".

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.

SUM({\$<Date={">=\$(v_MonthStartDate)<=\$(v_MonthEndDate)"}>} condition_value)/\$(v_LatestActualDate)*
only({<Date={">=\$(v_MonthStartDate)<=\$(v_MonthLastday)"}>}day(Date))

BR,

Rupali

Creator

Hi,

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

Regards,

Saniya

Tags
Community Browser