User of Power function in RPD — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

User of Power function in RPD

Received Response
1
Views
1
Comments
Adz10
Adz10 Rank 2 - Community Beginner

Hi,

I am trying to develop this excel formula in OBIEE using Power function.

=((1+11.9/100)^-0.25)*(Auth Total Interest + Auth Total Fee)

=((1+0.119)^-0.25)* (Auth Total Interest + Auth Total Fee)

Can anyone please help to get the right syntax. I am not sure how to apply power of -0.25.


Thanks

Answers

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    In rpd you can use Power Function (it's in Mathematic Functions).

    For example:

    POWER((1+11.9/100),-0.25) * (Auth Total Interest + Auth Total Fee)