Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We created a cyclic group ("Time Cyc") that cycles through time variables - e.g. year-week, year-month, year-qtr.
I'd like to use if functions based on the currently selected value of the cyclic group.
e.g.:
if([Time Cyc]={'year-qtr'}, 1, 0)
but if appears I can't use the cyclic group as I would use any other variable........
can it be done? how?
Many thanks
Al
Hi Al,
You can get the selected field within a cyclic/drilldown group by using the GetCurrentField function:
if(Match(GetCurrentField([Time Cyc]), 'year-qtr'), 1, 0).
Hi Al,
You can get the selected field within a cyclic/drilldown group by using the GetCurrentField function:
if(Match(GetCurrentField([Time Cyc]), 'year-qtr'), 1, 0).
Cheers! It works!
Many thanks