Not able to use excel formulas in webi

[Former Member]

Hi All,

We have a universe created on excel data source and one of the column in excel is based on variance calculation. If we create a deski report its working fine with variance column/object. But we are not able to create a Webi report please help.

[Former Member · Accepted solution]

Hi,

Try This .

Create New Object For Your Variance in Universe & Calculate it from Universe

Or

Use Your Excel Directly in Web Intelligence If You Have Every thing calculated in Excel .