Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created an variable called "vDate" for "My_Date" field and wonder if it's possible to select multiple dates via an InputBox and Date Slider? For the Slider, i couldn't even populate the date data via variable selected. Attached sample QVW.
Any Input greately appreciated!
Thanks,
Frank
Try this:
RangeSum(
Sum({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount) + Avg({<My_Date = {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>}1000),
Sum({<My_Date -= {"$(='>='& Date(vDateStart) & '<=' & Date(vDateEnd))"}>} Amount))
Thanks Sunny. Not sure how "AVG()" plays a role in this RangSum..
Just so we can use the set analysis to add 1000 to just the selected range. You can replace it with Only()