| Original Message |
Anonymous
Posted Jan 10, 2012 12:28 AM
Thanks all for your responses..
even i beleive HTS is not much useful, but some area in my demo project, i need to show something like, "how a project is evolved through out from the start" i.e. a project may span across multiple years or a project is still runnign for a past 5 years etc..so they want to see somethign like what is the total cost incured for this project till date (inception to date i beleive)....so what i did is i wrote this as a member formula, and am gettign the desired result, but not sure whethetr its a perfect coding standard or not...any input is much appreciated....in my demo app, start yr id FY11... :-) i uploadded some dummy numbers and i set my app current year as fy13....just some junk numbers in the cube...
"HistoryToDate" =
@SUMRANGE("Jan" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Feb" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Mar" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Apr" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("May" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Jun" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Jul" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Aug" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Sep" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Oct" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Nov" , @XRANGE("FY11",&CYMinus1)) +
@SUMRANGE("Dec" , @XRANGE("FY11",&CYMinus1)) ;
IF ( @ISMBR (&CY) )
"HistoryToDate" = "HistoryToDate" + @PTD("Jan":&CM);
ENDIF;
|
|
|