Help with calculated dimension

[Anonymous]

Hello all,

So i have this dimension:

=if(($(maxIndexFY_Q)-4)<=[Index_FY-Q],[Index_FY-Q])

where:

Index_FY-Q: field, it is a number for each quatrimester in ascending order from the 1st Q of the 1st Fiscal year. it has only this values : [1 2 3 4 5]

maxIndexFY_Q = maxstring({<[Index_FY-Q]=>} [Index_FY-Q])         //get the highest value of Index_FY-Q, in my case it returns 5

Somehow i can't get this dimension to work. Why? I ave done more calculated dimensions and didn't have a problem.

The objective is to represent the 5 last quatrimesters (including the current one). (can't use new script dimension)

Thanks for help ^^

[sunny_talwar]

May be this

=If(MaxString(TOTAL {<[Index_FY-Q]=>} [Index_FY-Q]) <= [Index_FY-Q], [Index_FY-Q])

[Anil_Babu_Samineni · Accepted solution]

If you are calculating left hand side, You may need TOTAL keyword

[sunny_talwar]

or store your variable with an equal sign (without TOTAL)

[Anonymous]

This worked perfectly, i only changed it like this: maxIndexFY_Q = maxstring({<[Index_FY-Q]=>} [Index_FY-Q])

I also realized that i can use as dimension Index_FY-Q and at dimension limits restric to 5 largest! I didnt realize until now, but anyway thanks for the help!