Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.