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
Define your variables like:
varSelectDateMin = Date(Min(Postdate))
varSelectDateMax = Date(Max(Postdate))
And expression like:
Sum({$<Postdate ={">=$(=MonthStart(varSelectDateMin))<=$(=varSelectDateMax)"}>} Value_Exp))
But eventually(if you are supposed to select in the month field) it seems to be equivalent to simple: Sum(Value_Exp)