Set Analysis <= Date

[james]

All, I have been using IF statements, which seem to drag the speed

=sum(If([FCST.Date] <= vMaxDate,if(PlanVersion='0',Rev)))

I cannot seem to get the above to work in set analysis

Help?!?!

I have been trying

sum({$<Date = {FCST.Date <= {vMaxDate},[PlanVersion]= {'0'}>} Rev

[#2]

Here is an example I used which may help you a little bit... Be careful though, set analysis can get pretty slow as well.

Sum({$<[_kDate] = {"<=$(=addmonths($(vMaxActualDate),-12))"}>} [Actual Cost])