Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

@PRIOR @MDSHIFT

834075May 18 2012 — edited May 20 2012

I need to calculate a Member for FY2012 as follows:

FIX("Feb")
"Member1" = "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> "FY11" + "Member2" -> "Oct" -> "FY11" + "Member2" ->"Sep" -> "FY11"
ENDFIX

FIX("Mar")
"Member1" = "Member2" -> "Feb" + "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> "FY11" + "Member2" -> "Oct" -> "FY11"
ENDFIX
.
..
..and so forth.
this is a simplified formula but basically i want the formula to go back to previous year as well. using @PRIOR but the rangelist can be either period or Year, while in @MDSHIFT it can be in both current year and previous year.. is there a way I can achieve or have to write these detailed formulas by fixing on each month.

Thank You for your help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2012

Added on May 18 2012

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

1 comment

211 views