Variables in Set Analysis Expressions

[cfountain72]

Hello,

I'm trying to use a variable in my set analysis, but am either getting an error, or no results, or everything. Here is my expression where vCalendarSelection is variable (it's a date which is either a Fiscal or Calendar start date, based on a filter selection):

=Sum({$<FPMeasureDate={"$(= '>=' & Date(Max(vCalendarSelection)) & '<=' & Date(Max(FPMeasureDate)) )"}>} FPValue)

Any suggestions?

Thanks in advance,

Chris

[dwforest]

if its a variable needs a $() around it

=Sum({$<FPMeasureDate={"$(= '>=' & Date(Max($(vCalendarSelection))) & '<=' & Date(Max(FPMeasureDate)) )"}>} FPValue)

I think you could also use:

=Sum({$<FPMeasureDate={">=Date(Max($(vCalendarSelection)))<=Date(Max(FPMeasureDate))"}>} FPValue)

Date vars in Set Analysis can be tricky. The field FPMeasureDate must be in your default Date Format 

[cfountain72]

Thanks...however, neither of those are working for me. They both yield sums of 0. Any other ideas?