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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

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!