Using Variables in BI Publisher

Question

Hi Team,

I have the issue using variables and calculations. Can anyone please help. The below screenshot is Template.

Expected Output:

In the above screenshot, facing issue in 'Division %' row. Each column to be calculated as (Department Total / Project Total) * 100.

For Ex. B column (182/611) * 100,

C column (144/611) *100 like that. Please let me know, how to achieve this. Thanks.

Sinduja Sekar-Oracle · Answer

Hi @Kavitha D ,

Thank you for visiting and posting in Oracle Analytics Cloud (OAC) Product Community Page.

This forum is for OAC product and looks like your question is for BI Publisher.

Kindly use the below URL to post BI Publisher questions, submit ideas, receive support from our BIP experts and check out the resources they have available for you.

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

Regards,

Sinduja