Set Analysis Syntax

[kishoreravi1983]

Hi Team,

Can you Please help me to fix this expressions.

Actual Expression:

=sum({$*<Version = {'AOP'}, KPI_Attribute_1 = {'Numerator'}, KPI_Attribute_2 = {'$(v_Aggregate_On)', 'Auto'}, Year =, Quarter=, Month=, %FiscalPeriod.KEY = {'$(vCurrentYear)0$(vCurrentMonth)'}>}[# Measure])

Need to Replace Variables with Actual Variable Exp. Bez its not working in Alternate states

vCurrentYear =right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)

vCurrentMonth =left(max(%FiscalPeriod.KEY), 4)

I am Trying this

=sum({$*<Version = {'ACT'}, KPI_Attribute_1 = {'Numerator'}, KPI_Attribute_2 = {'$(v_Aggregate_On)', 'Auto'}, Year =, Quarter=, Month=, %FiscalPeriod.KEY ={$(="left(max(%FiscalPeriod.KEY), 4)")},
 %FiscalPeriod.KEY = {$("=right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)")}>}[# Measure])

Can some one help me to fix this it would be very great help.

Regards,

Ravi

[sunny_talwar]

Your year is only 2 characters and Month is 4?

vCurrentYear =right(max({<Version = {'ACT'}>}%FiscalPeriod.KEY), 2)

vCurrentMonth =left(max(%FiscalPeriod.KEY), 4)

Or is it the other way around??

[kishoreravi1983]

Hi Sunny,

Sorry it was my copy paste mistake the community. not at expression level.

What ever is  in the variable  need to fit directly in expression.

Regards,

Ravi

[sunny_talwar]

How exactly does your field %FiscalPeriod.KEY look like? Would you be able to share a screenshot of a list box on %FiscalPeriod.KEY