| Re: SubstringFebruary 12 2013 at 9:38 AM No score for this post | GlennS from IP address 63.127.232.196 |
Response to Substring |
| Since these are member names and I assume you have parents that denote the years, you could use the ISancestor function for the currentmember. Note ISAncestor does both ancestors and descendants dependent on the order of members so something like
Case When ISANCESTOR(time.currentmember,time.[FY10]) Then
....
When...
End
Note you might need to switch the two paramaters, I never remember which goes first |
| Responses- Re: Substring - Kiran on Feb 20, 9:35 AM
|
|
|