Multiple String Values in IF-THEN Statement

[mdfr]

Hello. I am trying to create a link to a sub-report based on an IF-THEN statement. The naming standards on a "Period" time dimension for current period and year-to-date are different in the two reports and I need to pass both values to the sub-report so it can filter on those specific naming standards.

Currently, the formula has this logic which only passes current period...

IF {?TIME PROMPT} = 'PER01'
THEN 'P01'
ELSE
IF {?TIME PROMPT} = 'PER02'
THEN 'P02'

What I really need is something that effectively allows the following:

IF {?TIME PROMPT} = 'PER01'
THEN ['P01','Y-T-D(P01W4D7)']
ELSE
IF {?TIME PROMPT} = 'PER02'
THEN ['P02','Y-T-D(P02W4D7)']

You cannot use the above logic to pass more than one string value. Does anybody know how to do this?

Thanks in Advance...

 

[hilfy]

You could create another formula in either report that will translate the "POx" values to tye "Y-T-D" values. If you do this in the the main report, you'll pass it into the subreport as a parameter, or you can just do it in the subreport based on the link for the period and not have to pass it in.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.