Skip to Main Content
Forums

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!

Member - Data Type: Date in PBCS

Alex1May 4 2016 — edited May 5 2016

Hello! I have to create two members in my account dimension with data type "date", users should input a date, like : 11/03/2016, 30/05/2016.... and then I have to create a dynamic calc account that have a substraction between account 1 and account 2 with number of days. For example If user type in first account: 15/04/2016 and type on second account 3/05/2016 my third account should be: 18.

I create my member with data type: Date

pastedImage_1.png

and If I type in a form a date I have this error:

pastedImage_4.png

And finally I should have a third account that calculate number of days between first date and second date. I think that I should make with a dynamic calc...but I don't know.

Could you help me?

Thanks!
This post has been answered by Dan Gagnon on May 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2016
Added on May 4 2016
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
4 comments
1,209 views