How can I use Columns total?

HCL Domino Domino Forum
1

Is there any way that I can use two columns , that have total, to do something like : column 3 = column 2/column 1?

2

Subject: How can I use Columns total?

Notes views can not user other columns in computed formulas.

You would have to use the formula in each column but do note that it would tax the view itself.

HTH - Cheers

3

Subject: How can I use Columns total?

Why not

  1. Put a computed field on the form to do the calculation for you and display that field in Column 3?; or

  2. Do painful @DBLookups to get the values of the 2 columns into two temp variables and process the temp variables.

Personally, I would go with number 1. :slight_smile: