Function RelativePeriod - convert result and insert parameter

[KOKIUSMAT]

HI, 

I want to convert in a String variable the number variable that is result of a difference between two period calculated with function RelativePeriod .

Example: 1 = "positive" ; -1 = "negative" etc

But it's not possible because it is a aggregate calculated. Is there a solution?

Then I want to insert a parameter  in the "offset interval" but it accepts only numbers.  Is there a solution?

Thanks

[Sam_SAS · Accepted solution]

Hello,

I don't think you can make the output of RelativePeriod into a string, sorry.

For what it is worth, you can apply display rules to aggregated measure values. So you could highlight the positive/negative differences.

A workaround that is sometimes suggested when working with aggregated values is to create an aggregated data source to store the aggregated values.

For the offset parameter, I believe you could do something very inelegant like this:

IF ( 'Param'p = 1 )
RETURN <RelativePeriod expression with offset 1>
ELSE IF ('Param'p =2 )

RETURN <RelativePeriod expression with offset 2>

ELSE IF ('Param'p =3 )

RETURN <RelativePeriod expression with offset 3>

And so on.

You could give it a try.

Let us know if that helps.

Thanks,

Sam