Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems
Business Objects - Webi - Formulas
This article details several advanced formulas that can be created in BI Launch Pad
Is there something you want to learn to do in BI Launch Pad? Have you created an interesting report or formula that others should know about? BIS is looking for your ideas and techniques to share with other users and to build a library of advanced topics and sample reports. Please contact us if you have a topic you need to learn more about or have a report or technique you would like to share.
Presented here are formula questions BIS has received that require knowledge beyond the basic training along with the documentation of the steps used to resolve them.
Using the Financial Reporting Universe, how do I calculate the Balance Available less the In-direct costs (aka the Direct Cost Available) for a Grant
Add the <IDC Rate> to your query results and then create a formula as follows:
=<Budget Bal Avail Amt (SL10)>/(1+(<IDC Rate>/100 ))
Note that the <IDC Rate> isn't stored as a percentage (.2 for 20%) but as a number (20) so it has to be divided by 100 to get a percentage.