Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BIP Conditional Data Formats — 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 Conditional Data Formats

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 5 comments


BIP Conditional Data Formats


Hi all,


Can we apply conditional data formats to BIP reports like we can do in Answers? I am using the RTF template builder. I have a parameter named p_scaling, values are a fixed list and are as follows:


m.0 (the measure should be divided by 1000000 and should have 1 decimal place)

bn.0 (the measure should be divided by 1000000000 and should have 1 decimal place)

m (the measure should be divided by 1000000)

units (just show the measure)


The division is going to be done in the data set using a case statement based on the parameter selection. But I'm not sure if the conditional decimals can be done in the data set too, since we need to set an overall formatting mask for the measure within the RTF template. Is there a way to add conditional data formats within the RTF template?

Howdy, Stranger!

Log In

To view full details, sign in.


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