Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Something that I would have thought should take me 30 seconds to write has now caused me multiple hours of research and dozens of iterations.
Simple I need 2 numbers:
Sum({$<ForecastDate = {'$(=Max({1}ForecastDate))'}>}ForecastUtilization)
Sum({$<ForecastDate = {'$(=Min({1}ForecastDate))'}>}ForecastUtilization)
With or without the {1}, adding quotes, removing them, changing around DSE, etc. . . .
SO, I went the variable route:
ReportDateTemp:
Load
max(ReportDate) as MaxReportDate,
min(ReportDate) as MinReportDate,
max(ForecastDate) as MaxForecastDate,
min(ForecastDate) as MinForecastDate
Resident ForecastData;
Let vMaxReportDate = Peek('MaxReportDate');
Let vMinReportDate = Peek('MinReportDate');
Let vMinForecastDate = Peek('MinForecastDate');
Let vMaxForecastDate = Peek('MaxForecastDate');
Drop Table ReportDateTemp;
Now I have vMinForecastDate and vMaxForecastDate = both of which display perfectly in a KPI box.
The set analysis is still defeating me.
I've tried:
Sum({$<ForecastDate = {'$(=$(vMinForecastDate))'}>}ForecastUtilization) //returns 0
Sum({$<ForecastDate = {'$(vMinForecastDate)'}>}ForecastUtilization) //returns 0
I'm sure it's silly. Hoping so, Help?
May be try using Date() function around your variable with the date format of your date field. I think the format mis-match might be causing this
May be try using Date() function around your variable with the date format of your date field. I think the format mis-match might be causing this
Yup, that was it. Glad it was simple. Live and learn.
Thanks again You rock!