Oracle Analytics Publisher

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

Using Variables in BI Publisher

Received Response
51
Views
1
Comments
Kavitha D
Kavitha D Rank 1 - Community Starter
edited Oct 26, 2023 9:40AM in Oracle Analytics Publisher

Hi Team,

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

Report template.jpg

Expected Output:

Expected Output.jpg


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.

Tagged:

Answers