Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'am trying to display the information until a user selected date, the problem is
Example:
The user wants the YTD until 5 June, so he selects in months the JAN, FEB, MAR , ... JUN, in the weeks 1,2,3,4..,23 but now the problem how i select all the day's until 5 June?
The solution was creating a button and set action "select in field": "my DateField" and the search string: = '>=' & vStartDate & '<=' & vEndDate, where my vStartDate it's the current year and vEndDate it's the selected date
If you need a sum of sales for example, then write
Sum({$ <myDate={'<=$(=GetFieldSelections(myDate))'}>} sales)
let me know
no is not a particular function but all the data displayed, like the drill does
The solution was creating a button and set action "select in field": "my DateField" and the search string: = '>=' & vStartDate & '<=' & vEndDate, where my vStartDate it's the current year and vEndDate it's the selected date