Hi expert,
I wish have a MDX formula in my account dimension..
The requirement is ..
get_bigger(%TIME_COMPARE%)
{
iif( time.currentmember.value >= %TIME_COMPARE% , time.currentmember.value , %TIME_COMPARE%.value)
}
%TIME_COMPARE% is a member from time dimension,
%TIME_COMPARE% will be from a property from my current category...
How actually to write this in correct syntax in MDX ???
THANKs