Monthly Run Rate

[#1]

Hi all,

jagan‌

I need a data from start of this month to yesterday.

count({$<CanonicalDate={'>$(=Date(Today()-20))<=$(=Today()-1)'}, DateType= {'invitation'}>} invitation_id)

and also i need to compare this value with the last month value how can i do this.

see the attached sample qvf file, The issue is i don't have recent dates data in the .qvf file.

Regards,

Pramod

[jagan]

Hi,

Your expression is entirely different than mine.  Correct your expression.

Give your expression like this

Formula: = (CurrentMonth - PreviousMonth)/PreviousMonth

Note: Replace CurrentMonth with your current month formula and PreviousMonth with previous month formula.

Regards,

jagan.