How to add first column value and third column value of same column and display in last column.
Example : (1 + 8 = 9) using cell values in above GridView on click event of TextBox.
| |
Functional Currency |
Current year |
Year 2 |
Year 1 |
| 1 |
Gross Profit / Gross Margin |
textbox |
- |
- |
| 2 |
Depreciation/Amortization |
textbox |
- |
- |
| 3 |
Operating Income (EBIT) |
textbox |
- |
- |
| 4 |
Total Interest Expense |
textbox |
- |
- |
| 5 |
Net Income |
textbox |
- |
- |
| 6 |
Cash Flow from Operations |
textbox |
- |
- |
| 7 |
Interest & Principal payments [EMI] on borrowed funds |
textbox |
- |
- |
| 8 |
Debt Service Coverage Ratio |
count(Operating Income (EBIT) current year values + Depreciation/Amortization current values )/Interest & Principal payments [EMI] on borrowed funds current value |
|
|
