Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am facing a problem in the set analysis expression, I have an inline table in which I have 'this month','last month','last 6 months' as columns so when the user selects any of these then the value should filter based on this , so I am passing the value in the set expression as variable but I am not able to get the value
The expression is:
"IF(
GetFieldSelections([swL12W])='This Month'
,'MonthYear={"<=$(=date(Date(Today()),'MMM YY'))"}' -
, IF(
GetFieldSelections([swL12W])='Last Month'
,'MonthYear={"$(=date(addmonths(Date(Today()),-1),'MMM YY'))"}'
, IF(
GetFieldSelections([swL12W])='Last 6 Months'
'MonthYear={">$(=date(addmonths(Date(Today()),-6),'MMM YY')) <=$(=date(Date(Today()),'MMM YY'))"}'
)
)
)"
the column name MonthYear is having the month as 'Aug 16'
and I am storing it in the variable 'vSwitchMonths' and I passing it in the expression as
sum({<$(vSwitchMonths)>}units_delivered)
so can someone help me out in rectifying my error
Thanks,
Vivek
What is the exact error that you are facing?
it is not displaying any value
Would you be able to share a sample?
'MonthYear={"<=$(=date(Date(Today()),'MMM YY'))"}' - what is - here?
In MonthYear column it is passing as 'Sep 16'