EPBCS Essbase Member formula NOT working
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.