Oracle Analytics Cloud and Server

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

Calculations on report created using bip using rtf template

Question
1
Views
0
Comments
jameelj
jameelj Rank 1 - Community Starter

I am creating my first BIP report. I am using RTF template to build this.

My question here is can I do the calculations like total revenue = income1 + income2  or net margin = income - expense on the report level rather than doing at the datamodel level.

My sample dataset query result is

Queryid     Date     Amount

income1     June     125

income2     June     75

field browser value is set to

<?for-each:G_1?><?if:QUERY_ID='income1'?><?Amount?><?end if?><?end for-each?>

Request someone to share some info on this..

pastedImage_0.png