Set Analysis

[#1]

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

[MA1]

hi,

try to use this

PeriodID={"$(=date(max(PeriodID-1)))"}

[vinieme12]

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

Dates in Set Analysis

[#4]

Not Working, Showing same value

[ahaahaaha]

May be Today()-2 in expression?

[vinieme12]

post the expression you used or a sample app