Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have this set analysis, I want to calculate for same but exactly till YESTERDAY. Below is giving me detail till Now.
count({<Segment={'Retail'},PeriodID={$(=Max(PeriodID)) },Fin_Year,MonthYear=,Day=,Date= >} distinct Trans_Key)
I have Date as my Date fieldname.
Please Help
hi,
try to use this
PeriodID={"$(=date(max(PeriodID-1)))"}
what is periodID here? might want to take that out
count({<Segment={'Retail'},Fin_Year,MonthYear=,Day=,Date={"=DATE(Today()-1,'YOURDATEFORMAT')"} >} distinct Trans_Key)
read more here
Not Working, Showing same value
May be Today()-2 in expression?
post the expression you used or a sample app