Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])