What is wrong with this expression?

[timmy]

Hey,

What's wrong with this?

=sum({$<Fiscal_Quarter={$(#=(maxstring(Fiscal_Quarter)))}>} Sales)

If i try this every works

=sum({$<Fiscal_Year={$(#=(maxstring(Fiscal_Year)))}>} Sales)

My dimension for both expresions is Fiscal_Quarter

tnx

[villafuerte]

Hi Timmy,

Maybe it doesn't work because you're trying to get a number with the "#="

What's the format of Fiscal_Quarter?

[#3]

What do you mean by 'wrong'?

[timmy]

Your correct!

how can i perform this?

=sum({$<Fiscal_Quarter={'Q' & ' ' & {$(=right(maxstring(Fiscal_Quarter),2))}>} Sales)

[villafuerte]

Hi Timmy,

Can you upload an example file so we can see the formats and selection you want to display?

Cheers

[villafuerte]

The code you wrote had more or less the correct structure, but the string concatenation ( Q & '' % ...) is also an operation, so you need to evaluate it before the comparison in the set analysis.

However it would be easier to show you with a mock file.

Cheers