548107_en-US

liliconcom

use a value to find the correct column to use in a formula

Hi,

I have a summary table where I'd like to create a new column 'Rate' with a formula. The column MAXRESULT gives the name of the column I want to use in the formula. unfortunately, I'm getting 'missing arguments' error when I create the formula based on column name.

Column 'Rate' formula: 

(100 * Column Name( Parse( "N(" || Char( :MAXRESULT ) || ")" ) )[]) / :N Rows

 

 

What's wrong ?

 

Scripting