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.




Keywords:bis irf webi BO GEMS AURA SDW   Doc ID:19616
Owner:James I.Group:University of Chicago
Created:2011-08-07 18:00 CSTUpdated:2016-08-02 10:46 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  3   1