Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
BIP RTF formula? division and math formula — 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

BIP RTF formula? division and math formula

Received Response
16
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Content

I'm trying to get a formula to work within an RTF template and this isn't working:

((sum(current-group()/PRIOR_EXP) + sum(current-group()/CURRENT_EXP)) div sum(current-group()/Budget)) * 100

The division piece seems to be failing but I don't know why:

(sum(current-group()/PRIOR_EXP) + sum(current-group()/CURRENT_EXP)) div sum(current-group()/Budget)

Moving the math to the query is not an easy option. I'd like to do this in the BIP RTF if possible.

Thanks,

John

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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