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!

Calculating Difference in Dates (in days) in Member Formula

3588477Jan 21 2019 — edited Jan 22 2019

Hi Experts,

In On prem Hyperion Planning version 11.1.2.4, I want to write a Dynamic calc Member formula which will calculate the tenure of the Employee from the Hired date. I used the following member formula but it didn't work

[OpenInputValueBlock]

IF (@ISMBR("Budget"))

@DATEDIFF(@CalcMgrGetCurrentDate(), "Hired Date" , DP_DAY);

ENDIF

[CloseInputValueBlock]

When i open the form, it shows the error that "Form is invalid". I refreshed the db but still get the same error. Has anyone idea on the date difference calculation (in days) using a member formula?

Thanks,

Pete`

This post has been answered by JohnGoodwin on Jan 22 2019

Jump to Answer

Added on Jan 21 2019

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

4 comments

747 views