Variance

[srinivasmuriki]

I have a data table where a column has Net Interest Income, Net Fee Income and Revenues. I need to calculate a field equivalent to the above like, Other Revenues. Where Other revenues = Revenues - Net Interest Income and Net Fee Income.

Can some one help please.

[bhaskar_sm]

Hi,

you can create an additional calculated column or derived column based on your existing columns by using load script or on visualization using calculated fields. I would recommend calculating this column in the load script: 

sample data I have created to depict this :

i am assuming the formula for calculating other revenues is 

[Other revenues] = Revenues - ([Net Interest Income] +[Net Fee Income])

Net Interest Income	Net Fee Income	Revenues	Other revenues
40	45	420	335
45	47	343	251

Script:

LOAD
" Net Interest Income",
"Net Fee Income",
Revenues,
 Revenues - (" Net Interest Income" +"Net Fee Income") as [Other revenues]
FROM [lib://DWN/community1.xlsx]
(ooxml, embedded labels, table is Sheet1);

I hope this will help solve your problem.