MDX Scripting help

I want a calculated measure which increase by 2 upon each increase of issue count.


We have,
1 issue - Then Value will be 0
2nd issue - The value will be 2
3rd issue - The value will be 4
After 4th issue the value should be 4 only, the value will not increase after 4
for each issue now the value will be 4.


You could use the Rank function to return the rank number for issue from a sorted list and then multiply the value by 2.

If the calculated results exceeds 4, return 4.

Martins / eazyBI