EPBCS Essbase Member formula NOT working — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EPBCS Essbase Member formula NOT working

edited Jul 28, 2025 5:55PM in EPM Platform and Freeform 4 comments

This is so weird. Let me explain. I want to pull "Salary_By_Steps_WFP"→"Year3" value, which is $100.

Assigning this code to dynamic calc member formula works perfect:

"Salary_By_Steps_WFP"→"Year3";

But my problem is Year has to be built dynamically, depending on the number of years employee has been with company.

Month and Year in excel POV are FY26 and Aug, so TP-Date has value 20250800. That's correct because calendar Aug 2025 falls in FY26.

OWP_Start Date is 9/22/21, so in Aug 2025 employee has been with company for 3 years, so I need "Year3" to be dynamically built.

@Truncate(@CalcMgrDateDiff(@CalcMgrAddMonths("TP-Date", 0 ), @CalcMgrAddMonths("OWP_Start Date", 0 ), "month")/12 ), returns 3.00 perfectly.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!