Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys.
I did a Master Calendar work fine.
In my Expression i have to use 'Postdate'. it Works Fine. with this expression :
Sum({$<Postdate ={">=$(=MonthStart(varSelectDate))<=$(=varSelectDate)"}>} Value_Exp))
But when i Select 2 month, it gave me the data for the last month, i want the data for 2 months.
exp:
FEB = 20
MAR: 10
When i select feb and mar he give me only 10 , But i i need 30.
I know that the problem is related to Monthstart but i don't know how i can resolve it.
plz need help emergency.
thanks
Hi,
create two variables as
vMindate = Min(Date)
vMaxDate = Max(Date)
Sum({$<Postdate ={">=$(=MonthStart(vMinDate))<=$(=vMaxDate)"}>} Value_Exp))
HTH
Sushil
Thank you
Done
Hi,
if you issue is resolved then mark this thread as answered so that other get benefited.
Thanks
Srry but Still the isuue with this expression.
count({$<DATE2={">=$(=MonthStart(vMinDate))<=$(=vMaxDate)"}>}
if(Month(vMaxDate) =Month(InvoiceDate) ,VehicleNumber ))