How to use an if statement conditional on the value of a cyclic-group?

[#1]

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

[#2 · Accepted solution]

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).

[#3]

Cheers! It works!

Many thanks