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